Forum Discussion
Excel online - is there a possibility to preserve cell formatting on update of a pivot table?
Dear all, In standard MS excel desktop app there is a possibility to preserve cell formatting on update of a pivot table. The procedure is easy, I need to go to pivot table options and make sure th...
Please consider this:
• Use Excel Desktop for formatting tasks: If possible, open the file in the desktop app to apply and preserve formatting.
• Automate formatting restoration: If you are using macros or scripts via Office Scripts (available in Excel Online for business accounts), you could potentially automate the reapplication of formatting after each refresh.
Thank you for the response.
That works, when I format file in the Desktop app and then convert it to the online version the formatting stays as it is during the pivot table refresh.
Thank you again, this helps🙂