I'm afraid you'll have to move both this spreadsheet and the spreadsheets it takes data from to a new folder. Then if those external references use an absolute address (c:\data\excel\november.xls) you'll have to write some VBA code to cycle through all formulas and change the file location so that it reflects the new location.
If it's a static archive, you can - of course - edit>copy, than edit>paste special>values all worksheets in your spreadsheet. That creates a snapshot, so to say,totally independent of everything else in the world.
Hope this helps.
I have created a workbook in MS Excel that has external references (to other .xls files), to track monthly data along with a forecast (as the monthly data changes, the workbook updates). I would like to move a copy of the workbook to a "record" file, and I want "break" those external references so the workbook retains its data. Is there a way to do this easily?