Results 1 to 3 of 3

Thread: Excel 2010 - Save as activates properties window

  1. #1

    Unhappy Excel 2010 - Save as activates properties window



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have been struggling for a long time to find out why every time I click on save as button I see the properties window pop up (When I click save as, then write name and click save I come back to a worksheet (which still has the unchanged name) and see the properties window. Does not matter if I click OK or close it. Then the workbook is saved with the name I chose. ) I don't know if this was set up by mistake when I was testing the VBA or perhaps I have this by default. I checked in other user's excel (within my organization) and they do not have this problem. It is getting a bit annoying each time the window opens. Even if I close it, the workbook saves anyway. I checked if there is a template stored anywhere, I even copied a template from different computer but the problem still remains unsolved. This is the case only with excel, other office programs do not have this. Tried with F12 - the same thing. Tried my file on a different computer - no problem with saving, the window did not pop up. This means that the problem is somewhere on my computer. I tried also to repair Office, restarted, but the problem is still there. Running out of ideas what else I can do. Looked in the registry, but found nothing suspicious. Also, checked the templates in my applications and in program files.Also checked the group policy, but no software config there. The below screenshot was made during the save workbook as "test".Click image for larger version. 

Name:	Untitled.jpg 
Views:	34 
Size:	94.6 KB 
ID:	745

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,250
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    The only things I can think of:
    -Maybe you assigned a macro to a keyboard shortcut. I can't think that would affect this though...
    -Do you have any add-ins running that might be conflicting?
    -Do you have any code in the personal workbook that might be interfering?

    One way to check may be to run Excel in safe mode and see if the problem perists (from the command prompt try "excel.exe /s") If all is fine, then it points to add-ins or the personal workbook. Try disabling all Add-Ins and COM Add-ins and re-enable them one by one till you find which triggers the issue.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Thanks for the suggestions. I ran the safe mode and there was no problem so I installed excel again. It got fixed somehow

Posting Permissions

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