Functions and Formulas
 

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!!

Functions and Formulas
 

yep, just release the lock on the formulae and cals.


"Stockwell43" wrote in message
...
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!!

Functions and Formulas
 

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!!

"jiwolf" wrote:

yep, just release the lock on the formulae and cals.


"Stockwell43" wrote in message
...
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!!

Functions and Formulas
 

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

On Tue, 15 May 2007 11:44:01 -0700, Stockwell43
wrote:

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!!

"jiwolf" wrote:

yep, just release the lock on the formulae and cals.


"Stockwell43" wrote in message
...
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!!

Functions and Formulas
 

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!!!!

"Gord Dibben" wrote:

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

On Tue, 15 May 2007 11:44:01 -0700, Stockwell43
wrote:

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!!

"jiwolf" wrote:

yep, just release the lock on the formulae and cals.


"Stockwell43" wrote in message
...
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!!

Functions and Formulas
 

Thanks for the feedback.

Gord

On Tue, 15 May 2007 12:14:00 -0700, Stockwell43
wrote:

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!!!!

"Gord Dibben" wrote:

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

On Tue, 15 May 2007 11:44:01 -0700, Stockwell43
wrote:

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!!

"jiwolf" wrote:

yep, just release the lock on the formulae and cals.


"Stockwell43" wrote in message
...
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!!