Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
protection worksheets

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protection of worksheets

Protection of worksheets

ResolvedVersion 2007

Jale has attended:
Excel Intermediate course

Protection of worksheets

Is it possible to keep a master copy in my folder of my protected worksheet so that i can see exactly waht new data has been entered and how that has effect the protected worksheet?

RE: protection of worksheets

Hi Jale, thanks for your query. If I understand correctly, you want to synchronize data between two protected worksheets, including one in your folder. This depends a lot on what the circumstances are, but you could use 3-D links to connect the two spreadsheets together, conditional formatting to visually indicate what cells have changed, or use the import function to bring in worksheet data on a regular basis.

Hope this helps,

Anthony

Mon 15 Jun 2009: Automatically marked as resolved.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.