Forum Discussion
Having problem display conditional formating and time stamp on a shared excel sheet.
I've setup conditional formatting on a shared excel sheet where people can edit that file at the same time, but time stamp I setup to occur automatically when one of the column cell value is filled, it will not display on everyone’s spreadsheet and the highlighted rows supposed to highlight after the cut off time also is not display in the SharePoint version. As the creator when I open the file, everything is there for me to view.
Is there a way to make it appear on all the shared users' spreadsheet? Please help. Thank you.
17 Replies
- Thank you for the suggestion, I will test it out soon.
- Hi Marisal. It could be this as I have found problems with functionality when sharing sheets. When you share a sheet with someone it will open up in a browser. There is a button that says Open with Desktop App which is near the center just below the ribbon (easy to overlook) If they press this and close the browser when prompted all funtionality and formatting returns. I hope this helps 🙂
- The shared sheet is running on Window 10 Prof. plateform.
Microsoft Excel for Microsoft 365 MSO (16.0.14228.20216) 64-bitAs you can also read in the link, please add an Excel file (without sensitive data) and describe your plan on the basis of this.
Sorry for the inconvenience, but the more information is shared, the better and faster a suggested solution can be submitted.
Please understand that I am not the most suitable to propose a solution to you.
But with my suggestions, I would like you to be able to get a possible solution from the specialists as far as possible, without which I can guarantee this for you.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)- Hi Nikolino, how can attached a sample? Thanks.
If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!
Please include the following info to help others answer your question: Click on the Link
Welcome to your Excel discussion space!
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)- Thank you Nikolino. I will do that right now.
