Windows 10: Excel In Office Home & Student 2016 Global Changes Solved

Page 1 of 4 123 ... LastLast
  1. Wiley Coyote's Avatar
    Posts : 896
    Windows 10 Home x64 Version 1809 (OS Build 17763.55)
       03 Jul 2018 #1

    Excel In Office Home & Student 2016 Global Changes


    Between yesterday and this morning something's changed. Previous settings for ALL workbooks had Page Setup/Sheet Tab configured to print Gridlines and NOT the Row and column headings for all the spreadsheets in all workbooks. The opposite of what's displayed.

    Click image for larger version. 

Name:	Excel.PNG 
Views:	41 
Size:	12.9 KB 
ID:	194432

    As of this morning this is reversed in every workbook and when I change this it does not get saved in any of the workbooks. What do I have to do to get this back to my original setup? Any other changes or editing data does get saved. Just not the printing.

    I really need some help with this. As always, TIA for your time, attention, and help.
    Last edited by Wiley Coyote; 03 Jul 2018 at 10:52.
      My ComputersSystem Spec

  2. Caledon Ken's Avatar
    Posts : 10,584
    Windows 10 Pro x64 Build 1803
       03 Jul 2018 #2

    I don't have that version and there does not seem to be a setting for same, globally, in 2013.

    Were updates applied to Windows or Office yesterday?

    Real long shot, was your print driver(s) updated. What happens if you pick different printer, can you save changes?

    Might be worth running the Office repair.
      My ComputerSystem Spec

  3. Wiley Coyote's Avatar
    Posts : 896
    Windows 10 Home x64 Version 1809 (OS Build 17763.55)
    Thread Starter
       03 Jul 2018 #3

    I can't find any global print settings either.

    Best I can tell, no updates for Windows or Office since my last printing. Don't look like drivers updated either.

    I'll see what I can find about Office Repair.
      My ComputersSystem Spec

  4. Wiley Coyote's Avatar
    Posts : 896
    Windows 10 Home x64 Version 1809 (OS Build 17763.55)
    Thread Starter
       03 Jul 2018 #4

    Went ahead and did the full blown Online Repair. No change. Those settings are still not being saved. Margins, Headers, & Footers aresaved.
      My ComputersSystem Spec

  5. Caledon Ken's Avatar
    Posts : 10,584
    Windows 10 Pro x64 Build 1803
       03 Jul 2018 #5

    Did you change printers?
      My ComputerSystem Spec

  6. Wiley Coyote's Avatar
    Posts : 896
    Windows 10 Home x64 Version 1809 (OS Build 17763.55)
    Thread Starter
       03 Jul 2018 #6

    Only have the one. I did play with trading drivers and no change.

    After two hours of playing with this it's saving sometimes, but not more than twice. Just started on it's own. Then open the workbook and it's back to the NO Gridlines and Headings ON.

    Click image for larger version. 

Name:	Excel-2.PNG 
Views:	35 
Size:	15.0 KB 
ID:	194473

    Nothing else has changed in Office that I can find.
      My ComputersSystem Spec

  7.    03 Jul 2018 #7

    @Wiley Coyote I had similar problems with Home and Student 2010 version. Switched to free Libre Office, never looked back. Libre office is free and does the same, if not more than Office.
      My ComputerSystem Spec

  8. Caledon Ken's Avatar
    Posts : 10,584
    Windows 10 Pro x64 Build 1803
       03 Jul 2018 #8

    With regards to problem. If you start Excel from the icon and then start a brand new spreadsheet does it act the same?

    Any chance a theme may have been installed File > Options > General > In personalization section?

    EDIT:

    Please also check to see if any add-ins have become active.
    Last edited by Caledon Ken; 03 Jul 2018 at 16:33.
      My ComputerSystem Spec

  9. Wiley Coyote's Avatar
    Posts : 896
    Windows 10 Home x64 Version 1809 (OS Build 17763.55)
    Thread Starter
       03 Jul 2018 #9

    New Workbook/Spreadsheet has Guidelines and Headings off, Un-Checked.

    No new Themes installed. Colorful has been the default since Initial Install and Startup.

    No Active Add-Ins.
    @Stitch194 I can appreciate what you're saying. I'd like to keep Office unless it's unworkable.

    And @Caledon Ken I certainly appreciate your time and efforts to help me figure this one out. One or both of us are missing something.

    Edit:

    Copy or Move an existing spreadsheet into a NEW Workbook brings the "failed" print selections with it.
    Last edited by Wiley Coyote; 03 Jul 2018 at 18:43.
      My ComputersSystem Spec

  10. Caledon Ken's Avatar
    Posts : 10,584
    Windows 10 Pro x64 Build 1803
       03 Jul 2018 #10

    So new sheet is defaulting to normal excel, they are off by default on my 2013. If you turn on gridlines and save it, then open it and change it is it remembering format choices.

    Guess I'm trying to determine is it older worksheets that display this behavior or newer.

    By the way are these xls or xlsx spreadsheets. There is that save compatibility warning you can get and I think you can check mark such that it will stop warning or asking about saving compatibility.
      My ComputerSystem Spec


 
Page 1 of 4 123 ... LastLast

Related Threads
I don't want to lose all my information that is currently in word format. Do I install Libreoffice first then use add remove to remove MS to switch and keep my files? I do not know how to make the transition and not lose my data in my desktop and...
Thread tells it all. Forgive what's a simple question. I do appreciate the comments.
I have had a few problems winding up a new ACER Laptop for my Son. In our Family we have used Microsoft Office Home and Student 2007 version since new. and before that 2003 version, on clicking the ICON the familiar sandy coloured rectangle...
I plan on buying 2 Microsoft Office Home & Student 2016 programs: one for my win10 laptop & one for my Win10 desktop. --- Is it necessary to have a Microsoft account in order to install & use Microsoft Office Home & Student 2016? If I sell or...
Solved Office Home and Student 2010 in Microsoft Office and 365
My Office Home and Student 2010 became corrupted with Win 10 Anniversary edition upgrade. I need to un install / re install this software. This was pre installed on my PC and I have no copy of the original software and I cannot find a download...
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 21:02.
Find Us