protection and filters
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Protection and filters

resolvedResolved · Urgent Priority · Version 2007

replyReply Thu 23 Sep 2010, 17:24Delegate Liz said...

Liz has attended:
SharePoint course

Protection and filters

Hello

When we apply protection we seem to lose the facility to use data filters....is there any solution to this problem please?

For upcoming training course dates see: Pricing & availability

replyReply Tue 28 Sep 2010, 14:20Trainer Jacob said...

RE: protection and filters

Dear Liz



Further to your forum post we would need to see your working files and an itemised list of the issues you are facing.



We can then review and see if we can assist. If we can find a solution we will let you know the scope of work and any associated costs to complete.



Please feel free to send the files to me direct.

Tue 5 Oct 2010: Automatically marked as resolved.

 

Please browse our web site to find out more about
microsoft+excel+course and other Microsoft training courses.

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard