Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Excel cell formats changed after Windows Update

28 Aug 2016   #1

Win7 Pro x64
Excel cell formats changed after Windows Update

Hi. After getting my wife's laptop with Win 7 Pro to run it's updates again after a week's worth of struggling with that, she opened an existing LARGE spreadsheet to find that all the green cell contents were now blue, and the cells with $ formatting were now general format again !! Not a happy camper !
Has anyone ever experienced anything like this after Windows Updates ? Could something have affected the palette settings for the colors ? Over 120 updates (mix of security, Office 10, net frame etc.) were done so a little tough to identify the potential culprit.

Thanks for any insight.

My System SpecsSystem Spec
28 Aug 2016   #2

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium SP1, 64-bit

No, I've never seen that. I have a bunch of color-coded Excel stuff, but updates have never affected it.

You may have to do a System Restore to a time before the updates, if you'd rather give up the updates than deal with the Excel issues. I assume the Excel formatting issues can't be easily corrected.
My System SpecsSystem Spec
28 Aug 2016   #3

Windows 7 Home Premium 64 bit sp1

Hi techless, welcome to the Forum.

You could try Repairing Office 2010. This MS website tells you how to do that & it pretty straight forward.

If that does not help, get back with more info on the problem.

I know this is not much help to you at the moment, but if you have files & spreadsheets that you really rely on it's absolutely essential that you have your system backed up.
My System SpecsSystem Spec

28 Aug 2016   #4

Win7 Pro x64

Thanks guys for the response. Turns out that some of the spreadsheets were from Office 2003, and 2007 so there may be a compatibility issue going on here as well. We do have the files backed up so we are ok there. I'll take a look at the link Ranger4 posted as well.
My System SpecsSystem Spec

 Excel cell formats changed after Windows Update

Thread Tools

Similar help and support threads
Thread Forum
Can I compare 2 Excel spreadsheets cell by cell?
I have an Excel 2010 workbook comprising a simple organization membership list, consisting of names, addresses, etc., for nearly 2,000 members, grouped into 5 chapters' sheets, in a single Excel 2010 file. Every time I sit down to enter updates for any member, or add new members, etc., I always ...
Microsoft Office
Excel, Clearing formats doesn't clear the background color
Hi all, This is quote from the "Microsoft Excel 2010 by John Walkenbach" book: "Clearing formats doesn't clear the background color in a range that has been designated as a table unless you replace the table style background colors manually". But, When I create a table and right click ->...
Microsoft Office
Excel cell
Office 2010/Excel I accidentally entered an email address into a cell and now I can't get rid of that format in that cell. No matter what I do, whenever I try to enter text into that cell it is always illuminated in blue and is underlined, just like email addresses are. How can I make this cell...
Microsoft Office
Excel 2010 Multiply cell
I am kinda stuck with this issue, basically what I want to do is multiply any number which is put in row H by 10 and put the value in the next cell in row I, how can I do this? Thanks
Microsoft Office
Excel: How can I insert the value of cell into ActiveX button caption?
Hi, I'm using Office 2007 and I have an Excel file that I have to update often. Therefore I will automate certain tasks using macros accessible by ActiveX Control command buttons. However, I would like for the captions to be relative to information found in certain cells; examples of a caption I...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 19:27.
Twitter Facebook