Formula updates with SAVE AS

J

JenG

I have 2 spreadsheets. Spreadsheet A has a formula that points to a cell in
Spreadsheet B. If I have both spreadsheets open then do a File Save As in
Spreadsheet B and save it as a CSV file then the formula in Spreadsheet A now
references the newly created CSV file rather than the previous Spreadsheet B.
I wasn't sure if the formula updates with the new file name by design or if
there is a way to prevent this other than ensuring Spreadhseet A isn't open
when I do the save as CSV on Spreadsheet B.
 
B

Bernie Deitrick

Jen,

That is by design. You can either not have A open when doing the saving, or save it prior to the
CSV saving, and then close it without saving afterwards, and the changed links will be discarded.

HTH,
Bernie
MS Excel MVP
 

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

error with countif formula on when adding linked spreadsheets 0
Collate data from one spreadsheet into another spreadsheet 2
Checkbox - Output results to a csv file 4
SAVE AS CSV, KEEP DATE FORMAT 2
Formula results display only after pressing Enter key 1
Long formulae 4
formula finds values in apparently blank cells 1
Multiple Spreadsheet,Not sure what to use? Vlookup works for first 5

Top