Cannot Save / Save As

[Jon von der Heyden]

I did a bit of browsing on this problem. Found others suffering the same but haven't found any conclusive answer yet.

Every so often when I attempt to save a file, (including save as), Excel won'r let me. By won't let me I mean:

• using Save doesn't appear to do anything
• using Save As doesn't either do anything, the dialog is not displayed and if I am doing via the File menu then the File menu is exited and the previous ribbon tab is displayed (i.ethe one I was on before clicking 'File')
• if I close the workbook I am prompted to save, close without saving or cancel. Clicking save just invokes the same msgbox again.

I can't work out when it goes into this mode. Some days I can work without this problem, other days I encounter this 2 or 3 times.

The only thing I could suspect was I think this started around about the time I installed xlDennis' code library. I have uninstalled the addin and so far so good, but I cannot categorically say that this was the cause.

Anyone have any idea?

Cheers
Jon

Edit: I have read this: http://support.microsoft.com/kb/271513
Doesn't seem to cover the issue I describe

 

[MrKowz]

I have never experienced this issue in the years I've been working with Excel. Does this seem to happen with a particular version of Excel? Would you be able to send me the xlDennis add-in (whatever that does ) so I can test it in a sandbox environment to see if I can replicate the issue?

 

[RoryA]

Are you using Excel 2010 and do you have PowerPivot installed?

 

[Jon von der Heyden]

You can download the code library here: http://xldennis.wordpress.com/download-xl-dennis-tools/

I am running Office 2010 Professional Plus 32 bit on Win 7 Ultimate 64 bit

 

[Jon von der Heyden]

Are you using Excel 2010 and do you have PowerPivot installed?

Yes.

 

[RoryA]

PowerPivot does not play well with (certain?) other COM add-ins, it seems. If you open the COM addins dialog and uncheck PowerPivot and press OK, then go back in and re-enable it, it should be OK. Unfortunately, you have to do that each time, so you'll probably want to write some code for it.

 

[Jon von der Heyden]

Nice one thanks Rory. I think I'll just leave PowerPivot uninstalled and just enable it when needed.

Thanks

 

[RoryA]

Yeah, that's what I do.