Pivot Table In Read Only/Locked Workbook

M

mouse88

Board Regular
Joined
May 24, 2011
Messages
148
If a user opens a workbook in read only becuase someone else is locking it would they still be able to manipulate a pivot chart in the workbook. Mainly just collapsing and expanding groups.

Thanks
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
You must log in or register to reply here.

Similar threads

J
  • Question
File opening as Read Only
Replies
5
Views
193
rlv01
R
R
  • Question
Is there a way to open a file that Power Query has locked as Read-Only?
Replies
0
Views
96
rcrumbliss
R
P
  • Question
Lock cells when text entered into another vba not working
Replies
0
Views
402
P4444
P
R
  • Question
Power Query and Pivot Tables/Charts
Replies
0
Views
141
RodneyW
R
D
  • Question
Conditional formatting on pivot table headers
Replies
0
Views
136
D_SQUARED
D

Forum statistics

Threads
1,215,133
Messages
6,123,235
Members
449,092
Latest member
SCleaveland

Share this page

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
Back
Top