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 that the field "preserve cell formatting on update" is ticked.
However in MS excel ONLINE version I could not find this option.
That is problematic, because at my work we are using pivot tables in excel ONLINE version and after every refresh we have to restore formats of pivot tables manually and that is time consuming.
Please, does anyone know if there is a possibility to preserve cell formatting on update for excel ONLINE and how to achieve this?
Best Regards
Vit
2 Replies
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🙂
