Saving a file that you do not want to update the links to other fi

D

Derric

I have a summary report file that is linked to other files that I update the
info each week. I give the summary file a new name each week(basically the
week ending date).When I save the summary report and open it up after the
second week instead of keeping the original info it keeps updating with the
most current info. How can I make the summary report file stop updating and
just keep the info that it was saved with originaly for that week only.
 
G

Gord Dibben

Edit>Links

Break the links which converts the formulas to values then save.


Gord Dibben 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

Saving a file and not allowing it to update cells 4
Reference constant cells in different files from a master workbook 1
Update links without opening other files 4
Update links in multiple workbooks simultaneously 2
Macro to Break Links Before Saving Sheet 4
Update link without openning the source/destination files 2
PowerPoint Change/update links to new source (PPT with charts & objects linked to Excel) 1
Changing multiple PivotTable filter items based on a cell value 0

Top