date jumps
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 » Date jumps from 2011 to 2012 in October

Date jumps from 2011 to 2012 in October

resolvedResolved · High Priority · Version 2010

replyReply Mon 31 Oct 2011, 10:05Delegate Navraj said...

Navraj has attended:
Project Intro Intermediate course

Date jumps from 2011 to 2012 in October

Hi,

I wonder if you can confirm if this is a bug in Project 2010 (I am pretty sure it was in 2007)?

As you can see, the highlighted task finishes on 04/11/11. However, the Gantt bar ‘jumps to 2012! It does this in the Team Planner view as well.

See the image below for more detail.

http://i42.tinypic.com/2zr2jv4.jpg

Any thoughts?

Thanks

Nav

For upcoming training course dates see: Pricing & availability

replyReply Mon 31 Oct 2011, 13:01Trainer Andrew said...

RE: Date jumps from 2011 to 2012 in October

Hi Navraj

Thank you for your question. One thing that might be worth checking is the financial year setting. Take a look at File > Options > Schedule and take a look at what has been set for Fiscal Year starts in (the third drop down). Most often this is set to January - a different month can make cause the Timescale to look odd. Let me know what you find.

Kind regards,
Andrew

 

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

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)


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