Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Cannot Saveas in Excel 2007

Jun 10, 2010 4:12AM PDT

I have a Dell Workstation Running XP SP3 32-bit. I am running Microsoft Office 2007. My problem is with Excel.

I open an .xls file or .xlsx file that is read only. I will click save as to save the document as a different file. The dialog box which allows me to choose my save location as well as my file name does not come up. It just sits there.

I have tried everything I can think of. I have uninstalled / reinstalled. I have tried a system restore to before the problem started. I have uninstalled and purged all office data I could find then reinstalled and the problem persists. I am out of ideas. My next move will be a new Hard Drive and a fresh install of Windows. I am open to any ideas you all may have.

Discussion is locked

- Collapse -
Re: cannot saveas
Jun 10, 2010 4:32AM PDT

A new hard drive is certainly unnecessary. A fresh install of Windows formats the current drive, and that is surely enough, because this isn't a hardware issue.

Did you already check the possibility of a somehow (some setting, some registry entry) corrupted Windows user account. The basic diagnostic: create a new Windows account and try there. It's MUCH less work to transfer the contents of the old account to the new account than to start all over. See http://support.microsoft.com/kb/811151

Depending on the circumstances it might be an option to use another method of copying the spreadsheet and than clear the read-only attribute. Open and Save As isn't the fastest way to do it.
But you don't tell those circumstances.

Kees

- Collapse -
Thanks You
Jun 10, 2010 4:39AM PDT

I didn't mean I would replace the HD because it was defective. I always install a new one so I can keep the old one in case the user has some data on it they need at a later date. I will try a new user account. Thanks You.

- Collapse -
Why open that? Why not copy it first.
Jun 12, 2010 11:14PM PDT

Before you open that file, why not copy it then remove the read-only flag then open it?
Bob