Excel won't Save or Saveas

[detroitpickles]

I don't know whether this is VBA or not. I have a big old Excel workbook with a large bit of VBA in it. There is no weird coding going on in there that I know of. It was written in Excel 2000 on both NT2000 and Win98. I opened it on my new XP box and WAMMO.

I click on the worksheet, and I locked up Excel. I opened it again and tried a SaveAs. It changed the name of the file (titlebar), but a dialog popped up saying "Document Not Saved".

I have up to date virus software and checked the file. No problems. I scanned the whole drive with no problems. I reinstalled Excel which fixed nothing. I reinstalled XP and then Excel again to no avail.

Any ideas why it dies on JUST this file???

 

[cfcanter]

Do you have any links to closed files? when this happens to me, I am usually linked to a files on my hard disk. If the file is huge like you suggest, you may be going to your hard drive, or worse a server file, several thousand times.

If you are aware of any links, open the link-to files first then open the problem file.

just a thought,
c2 Craig Canter
Cost Accountant
Sipex
Milpitas, CA

 

[detroitpickles]

Here is an update.

I checked for External Links and there are NONE in any of my worksheets.

I checked the Iterations settings under Calculation, and there was no difference, although there are Circular References on one sheet.

I switched to manual calculation, and unchecked "caluculate before saving". No difference.

I check my System Info from the About Help pulldown. Apparently by having Word 2002 on the system (came with it), and Office 2000, the machine "thinks" I have Office 2002, as it is listed in there along with Office 2000. So, I deleted Word 2002. System Info listed was removed. But, no difference.

So I looked at the Add-Ins listed under Excel in the System Info screen. There was "addinmgr.xla" listed, but it didn't exist on my system. So, from inside Excel, went to add-ins and clicked it, only to find it say I couldn't find it, did I want to remove it? Sure. No difference.

Any suggestions....