save .xls w/o the formulas just the numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jim sturtz - 17 Jul 2006 16:02 GMT

i have a .xls file that has been layed out very nicely (and i wasnt supposed
to change it), but the silly bugger who designed it, didnt put it the
formulas to relate various cells
where totaling stuff.

i thought i had seen someway to save the .xls with only the 'results' of the
calculations rather than w/ all the formulas in it i put in.

was that a figment of my imagination?

thanks.

jim

Reply to this Message

Jon Quixley - 17 Jul 2006 16:34 GMT

Jim,

What you are after is a copy of the values rather than the formula
that sit behind the calculations.
To do this is easy - Open the file and select all by clicking on an
cell on the page and hitting ctrl-A, then copy the whole page wit
Ctrl-C and open up a new workbook (you can do this first if you like)
next you are going to "paste special" into this new book. Click ont
EDIT and select PASTE SPECIAL, there are several options here, but th
one you are probably after is 1) FORMAT and 2) Values. The first optio
will recreate the file in the same format as the original (colours
boxes that sort of thing) the second option populates this sheet wit
the values without importing the formulae.

Cheers
Jo

Reply to this Message