Pivot tables using Macs

Pivot tables using Macs

Didn't find your answer?

... when I refresh the data all my formatting is lost.
The table option Preserve formatting is checked.
Can anyone help me?
Sally

Replies (1)

Please login or register to join the discussion.

avatar
By AnonymousUser
12th Feb 2003 09:59

Pivot table format
Can you clarify what format?

Are you talking about auto format? or

Are you talking about manual format you have done?

If it is case 1 then, you select pivot table format from pivot manue spreasheet with lightning icon. Then check you have ticked auto format option.

If it is case 2, then, you unticked (unselect) auto format option, and apply manually formats to pivot table. This should work.

I hope this helps.

Regards

Mr Nilesh Mandvia

Thanks (0)