ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   FORMATTING IS LOST AFTER THE REPORT IS REFRESHED (https://www.excelbanter.com/excel-discussion-misc-queries/155550-formatting-lost-after-report-refreshed.html)

sandeep

FORMATTING IS LOST AFTER THE REPORT IS REFRESHED
 
The formatting is lost when we refresh the report.

Please help me how can i retrieve the formatting the report after it gets
refreshed.



It very programtic to first store the formatting of each and every cell and
then re-store it back once gets refreshed



Thanks,

Sandeep

Zone[_3_]

FORMATTING IS LOST AFTER THE REPORT IS REFRESHED
 
I'm not sure what you mean by "report" and "refreshed". If you're talking
about a regular Excel worksheet, save a copy of the sheet that is formatted
the way you want it. After refreshing the original sheet, display the
formatted sheet, click on the rectange above the row numbers and left of the
column letters to select the whole sheet. Click on the format painter.
Display the report sheet and click on its rectangle to apply the formatting
to the whole sheet. James

"Sandeep" wrote in message
...
The formatting is lost when we refresh the report.

Please help me how can i retrieve the formatting the report after it gets
refreshed.



It very programtic to first store the formatting of each and every cell
and
then re-store it back once gets refreshed



Thanks,

Sandeep





All times are GMT +1. The time now is 09:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com