reference to closed workbook is changing

  • Thread starter Thread starter Jacob
  • Start date Start date
J

Jacob

I have spreadsheets that make references to a workbook on a separate
drive. when I copy, or 'save as' to my desktop or C drive, all the
links to the workbook on the G drive change to the C drive. the file
and path does not exist on the C drive. the cells actually change from
'G:/....' to C:/....' is there a way to prevent this from happening?
 
Jacob
I could not repeat what I thought your problem was; but, I am pretty
sure you could avoid by using the indirect function. That is what you
use when you absolutely positively want your formula to stay the same.
Good luck.
Ken
 
You must log in or register to reply here.

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

Import multiple workbooks to current workbook in specified row number 0
How to reference a cell from anther workbook without opening it 0
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Reference named range in closed workbook 23
Export Sheet Values to new workbook 20
importing data from closed Excel workbook 2
save user inputs from userform in a seperate workbook 6
Run macro from active workbook whose name keeps changing 20

Back
Top