advisorgerma.blogg.se

I can’t reload like I used to with the old laptop.Worked (but this morning I discovered something).īelow is what I wrote to my IT department looking for help - which hasn't been answered by them yet, as I just wrote this only this morning (Sunday). I've tried everything, approaching it from different angles and places but nothing I've been having the exact same problem as the rest of you, ever since my IT department loaded Office 365 onto my company laptop a couple of months ago. if that fails there needs to be a means of testing and identifying the corruption or, certainly for complicated spreadsheets, a method detailed to transfer formulas and data to a new spreadsheet which will not include any potential corrupted So my suggestion is that for this and similar issues that seemingly cannot be resolved by simple means, is to start with shutting down and rebooting, save the project as a completely different file (Save As, new name)Īnd try again. recreating a new, simple spreadsheet is no big deal but some workbooks are incredibly complicatedĪnd would take a long time to recreate. This corruption does not occur all the time but probably in unique circumstances which probably accounts for why you could not duplicate the issue. I had a similar experience with another function which necessitated recreating (copying the data), pasting into a new workbookĪnd saving anew. It is my belief that the file becomes corrupted in some way which then prevents the Conditional Formatting from working correctly. particularly when we state that it is the color we are trying to change! Read the instructions stating that you can only conditionally format these things. further more the MSFT responses treat us like children imagining that we are incapable or too stupid to I have to say that it is frustrating seeing several people with the same issue and getting the same stock answer from MSFT that seemingly helps no one.