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