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

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
You must log in or register to reply here.

Similar threads

V
  • Question Question
Lock unhide sheet in a workbook with a password
Replies
2
Views
176
offthelip
O
Y
  • Question Question
Pivot Table deletes on opening of workbook
Replies
3
Views
251
cooleomter
C
J
  • Question Question
How can I copy the grouping rules from one pivot table to another pivot table?
Replies
0
Views
399
jaza_tom
J
J
  • Solved
VBA/Macro: Adding Pivot table with connection string
Replies
1
Views
252
Jette3173
J
G
  • Question Question
Conditional Formatting applied to the whole column in Pivot Table?
Replies
0
Views
358
GoodInSheets
G

Forum statistics

Threads
1,224,586
Messages
6,179,730
Members
452,939
Latest member
WCrawford

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