absolute cells when linking to an external file

D

del

Is there a way I can force the formulas not to be absolute when the formula
involves linking to an external file. That is instead of the formula coming
back as
=[Book1]Sheet1!$A$1, it will be =[Book1]Sheet1!A1 (without the dollar
signs). This will help me make the linking faster. I'm looking at other
options other than the find and replce.

Thanks a lot,
del
 
B

Bernie Deitrick

del,

When you select your cell in the external file, press F4 immediately to cycle through your $
options....

HTH,
Bernie
MS Excel MVP
 
D

del

Oh gosh, you are so smart. Thanks for your help!!!

Bernie Deitrick said:
del,

When you select your cell in the external file, press F4 immediately to cycle through your $
options....

HTH,
Bernie
MS Excel MVP


del said:
Is there a way I can force the formulas not to be absolute when the formula
involves linking to an external file. That is instead of the formula coming
back as
=[Book1]Sheet1!$A$1, it will be =[Book1]Sheet1!A1 (without the dollar
signs). This will help me make the linking faster. I'm looking at other
options other than the find and replce.

Thanks a lot,
del
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel (2003) crashes when referencing to external workbook in freezeframe 0
Excel crashes when writing formula referencing to external workbookin freeze frame 11
Absolute Reference (again) 3
Linking and preserving in Excel 0
Absolute External Link? 1
External References - Forcing Relative File Referencing 0
Formula within filename link 2
Copy a sheet contained formulas from one workbook to another and remove file links 3

Top