I bet you didn't open two different instances of excel on the test pc.

The solution to keeping the formulas is to use a single instance of excel.

Rich wrote:

Hello --

I have a Office Excel 2003 SP3. Here is the situation ...
I have a Workbook that has many Worksheets that have some pretty
intense formulas. I open a second instance of Excel with a blank
Workbook. I highlight the whole worksheet and hit copy. I then Paste
over on the new Blank Workbook ... and low and behold ... it is just
copying the values (no formulas).

If I perform the exact same test in the same instance of Excel it
works fine. The funny thing is I am unable to reproduce this on other
machines. Does anybody have any ideas of how this could be happening?

Thanks,
--Rich

--

Dave Peterson