By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,028 Members | 1,825 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,028 IT Pros & Developers. It's quick & easy.

How to remove formula retaining the actual link in Excel 2007.

P: 75
Hi everyone,

I'm new to Excel VBA.

One of our user given links to file in Excel using =HYPERLINK() formula to a lot of cells (approx. 5000 Cells). Now the thing is they dont want to display formula, but link must be present to external files.

I tried with paste special & all, but not worked.

Please help me how to remove formula retaining the actual link..

Thanx in advance.
May 21 '10 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,492
I'm sorry, but I don't understand your question. perhaps you could include some sample data to help clarify?
May 21 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.