ExcelBanter - Formatting Bug on Read-Only Excel Files

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formatting Bug on Read-Only Excel Files (https://www.excelbanter.com/excel-discussion-misc-queries/166093-formatting-bug-read-only-excel-files.html)

Nathan

Formatting Bug on Read-Only Excel Files

When I make a workbook read-only and then email it to it's users, the the
formatting inside the charts data tables is lost (changed from "Currency" or
"Percentage" back to "General"). I'm using Excel 2003.

Any idea on how to fix this?

All times are GMT +1. The time now is 10:22 AM.