Locking files and slicer

Resolved · Medium Priority · Version 2016

Fri 6 Oct 2017, 16:32 Delegate Emma said...

Emma has attended:
Excel PowerPivot course

Locking files and slicer

How can I lock files so people cannot change the content but select different info using the slicers?

Tue 10 Oct 2017, 11:05 Trainer Wendy said...

RE: locking files and slicer

Hi Emma

Is this using Tables or PivotTables and Charts?

You can still use the Review > Protect Sheet and select both Edit Objects and PivotTable / Chart as permissions.

This should allow you to lock the contents of the cells but give them access to filter by Slicer and Timeline.

Have a great day further.

Kind regards
Wendy

Mon 16 Oct 2017, 14:19 Trainer Wendy said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Mon 23 Oct 2017: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips