Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Cannot Save / Save As

  1. #1
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,653
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    3 Thread(s)

    Default Cannot Save / Save As

    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
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

  2. #2
    Board Regular MrKowz's Avatar
    Join Date
    Jun 2008
    Location
    St. Louis, MO
    Posts
    6,648
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cannot Save / Save As

    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?
    - Posting guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes
    - Please use [CODE] [/CODE] tags when posting your VBA code. It retains spacing, so your code is easier to read, and therefore easier to debug.
    - Please back up your file before using any macros suggested!

  3. #3
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    32,713
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Cannot Save / Save As

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

  4. #4
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,653
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Cannot Save / Save As

    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
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

  5. #5
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,653
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Cannot Save / Save As

    Quote Originally Posted by rorya View Post
    Are you using Excel 2010 and do you have PowerPivot installed?
    Yes.
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

  6. #6
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    32,713
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Cannot Save / Save As

    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.

  7. #7
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,653
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Cannot Save / Save As

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

    Thanks

    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

  8. #8
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    32,713
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Cannot Save / Save As

    Yeah, that's what I do.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •