Paste Special not working

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.



didemps wrote:
>
> I have a file with data for a particular week with formulas in the cells
> which are using this data to produce totals, but when i copy these cells
> with the formulas and then "paste special" into a new worksheet for the
> following week (which has its own data which i want to total up using
> the same formulas from previous week) i am not getting correct totals.
>
> Sometimes when use the paste i dont even get the correct "paste
> special" dialogue box, instead getting prompted to choose a type of
> paste- excel 8, text or others from list. Others times when the correct
> "paste special" box appears, and i select "all" and then paste im only
> 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 the
> values from the new worksheet im working in (not giving correct new
> total).
>
> Ive tried on a couple of pcs and im pretty sure its not profile related
> - Is there anything in excel that would be causing the prob or is it
> just bad data somewhere??????????
>
> --
> didemps
> ------------------------------------------------------------------------
> didemps's Profile: http://www.excelforum.com/member.php...o&userid=29064
> View this thread: http://www.excelforum.com/showthread...hreadid=487900

--

Dave Peterson