Pivot Table Data Source Options

eagle1750

New Member
Joined
Oct 7, 2002
Messages
2
Hello,

I've searched the archives to no avail.

I'm a network admin, not an excel expert by any means. I've inherited a huge custom pivot table that was created in Excel97. We're now using Excel 2000 (running in a thin client environment).

In pivot table options I need to have the "save data with table layout" CHECKED for all of my users. Yet everytime they check it, the setting is NOT saved when they go back into the table. This doesn't appear to be a setting that is save in the users windows profile. How can I get this setting to stick?

Can anybody help with this issue?

Thank you,

Ron
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

eagle1750

New Member
Joined
Oct 7, 2002
Messages
2
FYI - this issue is solved by applying the e2kmac.exe patch that fixes an excel macro security glitch as well as this issue with data in pivot tables.
 

Forum statistics

Threads
1,144,214
Messages
5,723,057
Members
422,476
Latest member
beck85

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top