| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula updates with SAVE AS
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| no updates prompt at opening and save changes at closing | Excel Discussion (Misc queries) | |||
| Cell only updates when I go into formula bar | Excel Discussion (Misc queries) | |||
| date that updates itself daily, plus another formula please?? | Excel Worksheet Functions | |||
| a protected cell w/formula only updates only on file save? | Excel Discussion (Misc queries) | |||
| Trying again for workbook formula updates | Excel Worksheet Functions | |||
Threaded Mode
