Error that prevents Copy Worksheet to another Tab

J

Jeff

When I try to copy a worksheet as another tab in the same file or to another
excel file, I get the error listed below. I can move the worksheet, I just
can not copy it.

Microsoft Office Excel cannot access the file
‘C:\DOCUME~1\JEFFRE~1.JEF|LOCALS~1\TEMPâ€. There are several possible reasons:

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open
workbook.


Bullet point one has not meaning since at this point I am not trying to open
a file. The program has not problem opening files.

I don’t know about Bullet Point 2. I have not check on the programs that
load up at the startup file. However, this just started happening again.
There were no new programs added when this error started up again.

Bullet Point 3 doesn’t apply since I am not trying to save a file.

This error also pops up every time I open the Excel Program.

I uninstalled and reinstalled Office 2003. It was fine for about a week and
then happened again.

This is frustrating. Please help.
 
D

Dave Peterson

I don't know if this fits, but the only time I had this trouble is when that
single worksheet (to be copied) was corrupted. I rebuilt it and all worked ok.

As a work around, I would move the worksheet elsewhere and then close without
saving. Then open and move it back.

Does this only happen with this one workbook/worksheet or does it happen all the
time?
 
J

Jeff

Dave,

Thank you for the response.

What you wrote is eactly how I work around the problem. Thanks for the tip.

Since I uninstalled and then reinstalled office 2003 it has not happened as
often. However, it happens on more then one worksheet.

Sometimes when I open Excel 2003 I get the same message even before I open
the file. I'm thinking that one of my other programs must be causing it.
I'm guessing it could be an antivirus or antispam software.

Thanks for your help.
 
D

Dave Peterson

Does it happen with lots of different workbooks?

If it's just one (or a couple), then maybe those workbooks need to rebuilt.

If it doesn't happen all the time, I wouldn't guess that it was excel itself.
(But that's just a guess.)
 
Top