Excel cell formats changed after Windows Update

techless

New member
Local time
11:06 AM
Messages
2
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 ! :mad:
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 Computer

Computer type
PC/Desktop
OS
Win7 Pro x64
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 Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Ignatz Special; 4 speed manual gearbox; factory air conditioning; one of one
OS
Windows 7 Home Premium SP1, 64-bit
CPU
Intel Skylake i5-6600K, not overclocked
Motherboard
AsRock Z170M Extreme 4, micro ATX
Memory
8 GB HyperX DDR4-2666 (2 x 4 GB)
Graphics Card(s)
none; graphics are integrated on CPU
Sound Card
onboard: Realtek ALC1150; external: USB Behringer UF0-202
Monitor(s) Displays
Dell S2340M 23 inch IPS
Screen Resolution
1600 x 900
Hard Drives
System: Crucial MX100 series SSD, 128 GB;
Data: Samsung Spinpoint 103SJ, 1 TB;
Backup: WD Caviar Green WD30EZRX-00D8PB0, 3 TB
PSU
Rosewill SilentNight 500 watt fanless, semi-modular
Case
Antec Solo II
Cooling
Noctua NH-U12S; Noctua F12 intake, Noctua S12A exhaust
Keyboard
Microsoft 200 6JH-00001 USB
Mouse
Dell or Microsoft optical wired; USB
Antivirus
Microsoft Security Essentials and Malwarebytes Premium
Browser
Pale Moon
Other Info
All fans PWM; speeds at idle: CPU circa 500 rpm; intake circa 600 rpm; exhaust circa 600 rpm; CPU temps 27 idle and 47 C load in a warm room (27 C/81 F) when running Intel Extreme Tuning Utility stress test.
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.

https://support.office.com/en-us/ar...lication-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

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 Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Self built using existing case
OS
Windows 7 Home Premium 64 bit sp1
CPU
Intel i5 3570 3.4Ghz Ivy Bridge SKT 1155 quad core
Motherboard
Gigabyte Z77-HD3 SKT 1155 2xSata 3, 4x USB 3.0
Memory
G-Skill Rip Jaws 16Gb (8x2) DDR3 -1600 PC3 12800 CL 10 red
Graphics Card(s)
Gigabyte NVIDIA GT610 1Gb DDR3 810/1200 PCI-E 2.0 Silent
Sound Card
NVIDIA High Definition & Realtech High Definition Audio
Monitor(s) Displays
2 x Philips 226V4L 16:9 aspect ratio
Screen Resolution
1920 x 1080 HD
Hard Drives
Samsung 840 Pro 256gb SSD, SATA 3.
Hitachi Touro Portable 1tb, USB 3.0 HDD used for image b/ups.
PSU
Corsair VS450
Case
Codeng
Cooling
PSU fan & CPU fan
Keyboard
Logitech
Mouse
Logitech Wireless trackball M570
Internet Speed
Wireless 3G. 3mg down & 550kb up.
Antivirus
Bitdefender Internet Security 2020
Browser
Opera (Current Version) & Firefox
Other Info
MS Office 2013 Pro. Davis weather station software. MGE Nova 600 avr UPS.
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 Computer

Computer type
PC/Desktop
OS
Win7 Pro x64
Back
Top