loss of all formalea ina worksheet

[gavwhite69]

Have recently come across a very strange and exceedingly annoying excel
behaviour. I spent half a day putting together a complicated
analytical template. When I finishned I copied the relevant sheet into
a new (single sheet) workbook to send to a colleague. However, when I
cleaned the sheet (took out all my test data) I noticed none of the
formula were changing values.... check calculation in not set to
manual.... its not. What has happended is that both versions of the
sheet, the origin and the new workbook have lost all formula as if I
have pasted the whole sheet over itself as a paste special 'values'.
However, when I think about it similar things have happened over the
past couple of days, but I didn't really question them at the time.
whilst I am relative newcomer to Mac OFfice I have > 10 years
intensive experience with excel and don't think I would make a mistake
like this 3 or 4 times in two days.

anyone with similar experiences. Is there a mac keyboard shortcut that
I am absuing? a preference somewhere?

any help would be appreciated.
cheers
g

 

[CyberTaz]

Hello g -

What you describe sounds quite unusual to me. I'm sure you'll get response
from others, however.

The first thing that comes to mind is whether there is any Protection
applied with Hidden cells involved. When copied to another sheet/book the
values only (displayed content) get copied.

That could explain the sheet you copied *to* but not what happened in the
sheet you copied *from*. I can't think of any setting or option that would
cause the formulas to convert to values just because you copy the cells.

Can you supply any more detail - including Office & OS versions? What are
the "similar things" you refer to?

In the meantime - rather than copy/paste sheets, try the Edit>Move or Copy
Sheet feature to create you duplicate. Choose New Book form the drop-down &
makes sure to check the Create a Copy box.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Patrick McMillan [MSFT]]

Another possible explanation for what you are seeing is something that was
recently discussed on this list, which is the fact that Mac Excel supports
two slightly different forms of copy/paste: one when the marquis/marching
ants are showing around the copy selection and another when the marquis is
not showing. In the latter case, some Excel specific formatting (including
cell formulas) will be lost. So, if you copied the data from the original
sheet by selecting that data, then invoking the Copy command, and then did
anything that would cause the marquis to go away prior to pasting the data
to the new workbook (like pressing Escape or entering new data anywhere in
the active workbook), then the formulas would not show up when you paste
into the new workbook (only the values would).

However, this would also not explain why the formulas were removed from the
initial workbook that you're copying from.

Thanks,

Pat

Hello g -

What you describe sounds quite unusual to me. I'm sure you'll get response
from others, however.

The first thing that comes to mind is whether there is any Protection
applied with Hidden cells involved. When copied to another sheet/book the
values only (displayed content) get copied.

That could explain the sheet you copied *to* but not what happened in the
sheet you copied *from*. I can't think of any setting or option that would
cause the formulas to convert to values just because you copy the cells.

Can you supply any more detail - including Office & OS versions? What are
the "similar things" you refer to?

In the meantime - rather than copy/paste sheets, try the Edit>Move or Copy
Sheet feature to create you duplicate. Choose New Book form the drop-down &
makes sure to check the Create a Copy box.

HTH |:>)
Bob Jones
[MVP] Office:Mac

--
Pat McMillan
Macintosh Business Unit
Microsoft Corp.

This posting is provided ³AS IS² with no warranties, and confers no rights.