Sarah has attended:
Project Intro Intermediate course
Saving spreadsheets without formulae
how to you save an entire workbook/spreadsheet without formulae? And with the formulae shown to external links but without the links to minimise problems with corruption.
RE: Saving spreadsheets without formulae
Hi Sarah
Thank you for your question:
In response;
You have two questions here and to my knowledge they will not operate simultaneously, lets just take the first one, save worksheet without formulae;
Select your entire worksheet; little button between A and 1 top left of worksheet will do this or keyboard command CTRL+A.
Keyboard CTRL+C to copy then to Menu command Edit, choose the Paste Special Option and choose Values from the dialog box. All your formulae will be changed to Values including all links to other worksheets/books.
To display your formula in a workbook choose the keyboard command CTRL+Pipe key (above Tab, Below Esc and to the left of 1) this is a toggle switch so it will switch on or off as required.
I hope that has helped, Pete
