Functions and Formulas

S

Stockwell43

Hello,

I have what I hope is a simple questions. I have a spreadsheet that has
formulas and calculations in certain cells which I have locked and hidden so
no one can tamper with them. However, when I try to copy the spreadsheet into
a new workbook, I lose all the formulas and calculations. Is there a way to
do this without losing everything or do I have to keep replacing that
information each time?

Thanks!!
 
S

Stockwell43

Hello,

Thank you for your quick response.

I removed the checkmarks for both Hidden and Locked, copied the spreadsheet
and pasted it in a new workbook but again, the forumlas didn't follow.

Is there another way?

Thanks!!
 
G

Gord Dibben

If you are running two separate instances of Excel with a workbook open in each,
copying from one to the other copies values only.

Close one instance of Excel and open both books in the other.

Your copying will then work proerly.


Gord Dibben MS Excel MVP
 
S

Stockwell43

Bingo, that was it!! I did have two separate Excels opened. Didn't think that
would matter but I guess it does. Excellent piece of information to retain
going forward. Thank you for your on this it was most appreciated!!!!
 
G

Gord Dibben

Thanks for the feedback.

Gord

Bingo, that was it!! I did have two separate Excels opened. Didn't think that
would matter but I guess it does. Excellent piece of information to retain
going forward. Thank you for your on this it was most appreciated!!!!
Click to expand...
 
Top