Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training day courses near kent - Recalculating a protected worksheet

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

microsoft excel training day courses near kent - Recalculating a protected worksheet

Resolved · Low Priority · Version Standard

Reply Mon 19 Nov 2007, 14:29Delegate Karen said...

Karen has attended:
Excel Advanced course

Recalculating a protected worksheet

Hi,

Please can you let me know if protecting a Worksheet will effect recalculation of it?

We use an Excel Add-In called Vision to access our Sun database financials. We have the recalculate set to Manual to save recalc time and we then recalc by selecting F9, Shift + F9 or the Vision Recalc options of a selected Range, W/book or W/sheet.

Basically we want to protect certain (formula driven) fields from being changed but still what the user to be able to recalculate the w/sheet or w/book.

Thanks

For upcoming training course dates see: Pricing & availability

Reply Mon 19 Nov 2007, 17:24Trainer Amanda said...

RE: Recalculating a protected worksheet

Hi Karen

Thank you for your question.

As long as the cells you want people to be able to edit do not have protection applied, then the recalculation should still be carried out when you press F9 (for example) even if the cells containing formulas have protection applied to them.

I hope this helps.
Amanda

Excel articles

· Excel Macros for the Non-Programmer
· Special Characters in Excel
· Share And Share Alike - Use Excel To Collaborate As A Winning Team!
· How To Protect Your Work In Excel 2010
· Correcting Numerical Glitches In Excel

Excel tip:

Hiding a worksheet in Excel

Want to circulate an Excel workbook file but keep certain worksheets hidden from your colleagues' view?

You can do so by bringing up the sheet you wish to hide on your screen; then going to Format - Sheet - Hide.

It will not be immediately obvious that a sheet is hidden from view unless perhaps the sheet are still labelled Sheet 1, Sheet 2 etc.

To display the sheet again, you can go to Format - Sheet - Unhide on any of the other sheets in the workbook. A dialogue box will appear, allowing you to select the hidden sheet/s. Click OK to make the sheet/s reappear again.

View all Excel hints and tips