Hi

If I understand this right, you have a cell range with formulas, probably
like
='C:\my path\[filename.xls]Sheet100'!$C$4

Select this range. Copy.
Choose menu Edit Paste special select Values OK. Now the formulas in
the selected cells are replaced with their static numeric values.

HTH. Best wishes Harald

"beaches045" skrev i melding
...
Own a pet store, Use Excel XP, maintain a Daily Sales report which is set
up:

By Month, then by Day Of course - all department numbers are entered in a
column, the sales figures are posted, sub totaled at the bottom, discounts
deducted, sales tax figured, balanced against cash register tape, actual
cash
count, credit card count, itemized check count.

Totals are carried down and across for the cumulative month total.

This workbook is linked to a similar one for years 2000, 2001, 2002, 2003
and now 2004.

Lastly there is a recap sheet at the end - carrying forward each month's
final numbers by department.

OK, This has gone on for three years now. At some point can it ever end?

Can a set of numbers from a previous workbook which will not change be
"locked" in? So I can carry forward those "locked in" numbers to future
years? Rather than always needing to keep all of the previous years there
in
the same place...

It is quite difficult to keep all of the previous years together and in
the
same place.

It seems as though there is a greater chance for something being lost,
corrupted.

All in all it is just a very time consuming process setting up a new year.
Which is where I am now.

Wondered if someone out there who obviously knew how to properly and
efficiently use Excel could and would shed some light.

Thank you.