Hi All

I have created a number of charts based on various pivot tables looking at spend on various items. The pt has a number of slicers for filtering.

The issue is as follows and happens in both excel 2007 & 2013:

When the workbook is opened and the user views a chart without changing a related filter the DataTable currency fields are formatted with a $ prefix. If the user then applies a filter the format reverts to the expected format of a prefix.

This will happen each time the workbook is opened even if it was saved with the DataTables showing the correct format.

I have changed the data formatting on both the data and pivottable to no avail, only changing the filters seems to work.

I am now out of ideas :0( can anyone help.

Regards

Frustrated, confused

• Moved by Lanlan HuangMicrosoft contingent staff 23 hours 10 minutes ago

Hi

This is the forum to discuss questions about Microsoft Excel develop. For your question is not about Excel develop, I am moving this thread to the TechNet forum for Excel

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thank you for your understanding.

Best Regards

Lan