How to update Excel?

Hi John-Paul, and welcome to the Community!

As of today, EasyMorph can't update existing sheets while preserving the formatting. Instead, you can update a (hidden) sheet with unformatted (raw) data. Then, on the formatted sheet, use a pivot table that uses the raw sheet as the source. The benefit of using a pivot table is that it can update automatically on workbook opening.

Another way of solving the problem is to use queries in Excel to port data from an unformatted sheet into a formatted table on another sheet. It's described here: Using EM to populate an existing spreadsheet

1 Like