Please can someone help. Im afraid the document is too large to upload however Im hoping this is something simple.
The spreadsheet was shared and after being used by several people the data in the worksheet just displays grey. The formula bar still shows the info is in the cells. Please can you advise on how to unhide.
Many thanks
Is there some sort of conditional formatting applied? Go to Home tab, Conditional Formatting, Manage Rules?
Did someone just shade the cells?... Go to Home tab, in the Font section, check the paint can icon, click the down arrow next to it and pick "no fill".
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
shared workbooks often go completely gaga ,funny formats rows high lighted and so on
get every one to save a copy localy then unshare the work book. now compare the lot one of them is probably right, then get every one to put their data back into the best copy individually
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks