Saving static info from a Dynamic Excel sheet

Permabanned
Joined
19 Apr 2006
Posts
2,333
Location
West Yorkshire
The accountant at my work has an excel file that gets various bits of data from different excel files and workbooks.

He has asked me how he can save a copy of the entire workbook with the values as they are now, so that he can keep back dated copies.

So basically he wants a copy that wont update when he changes the other workbooks which are referenced by this master copy.

If you have any idea what I am on about then I would appreciate it.
 
As there are multiple (about 90) sheets in this workbook is there any way to just save the entire workbook with the values?
 
Back
Top Bottom