Paste Special not working

[didemps]

I have a file with data for a particular week with formulas in the cell
which are using this data to produce totals, but when i copy these cell
with the formulas and then "paste special" into a new worksheet for th
following week (which has its own data which i want to total up usin
the same formulas from previous week) i am not getting correct totals.

Sometimes when use the paste i dont even get the correct "past
special" dialogue box, instead getting prompted to choose a type o
paste- excel 8, text or others from list. Others times when the correc
"paste special" box appears, and i select "all" and then paste im onl
getting the formulas being used in the cell not actually any data
Other times if i paste i get some data but its not updated with th
values from the new worksheet im working in (not giving correct ne
total).

Ive tried on a couple of pcs and im pretty sure its not profile relate
- Is there anything in excel that would be causing the prob or is i
just bad data somewhere?????????

 

[Dave Peterson]

It sounds like you have two workbooks open in different instances of excel.

Try closing all instances (just to make sure), then open the first workbook.

Then use file|open to open the second--don't double click on the second file in
windows explorer.

===
If you want to try to fix this multiple instance problem (if you consider it a
problem):

Sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.