Recommendation - refresh data without formatting
Format content in Microsoft Excel using data formats.
If formatting is applied to cells and the refreshed data shifts, the cell formatting does not move to the new location. This can change the meaning of data.
If you use extensive formatting, refresh data without formatting so that the changes you make are not overwritten by formatting changes in the original report.
Note: While you can copy or move imported elements between worksheets
by using Windows Copy and
Paste commands, you cannot properly refresh the source data on the
copied content. Similarly, you cannot refresh content on a new worksheet
that was copied from an existing worksheet. The report elements on
the copied worksheet are no longer linked to the source data. You
must reimport the report or report element on the new worksheet to
properly refresh the source data.