Contact
I am based in the UK (Reading, Berkshire) and am contactable via email at chris@professionalexcel.com.
I'm always interested in hearing about Excel users' common problems, unique problems, and the down right unexplainable. If you have a burning question that a book can't answer, or a google search proves fruitless, feel free to drop me an email and if it's a useful subject, I'll add it to my blog.
Chris Read BEng MSc MBCS
November 20th, 2018 - 17:34
Hi Chris
The project manager and I have downloaded your GANTT chart spreadsheet and they are really Awesome. We would like to know if there is any way to use it with a Pivot Table, where we can select projects and the GANTT will change accordingly?
We currently use Microsoft Dynamics NAV to maintain all our timesheets and planning data. We then have a SQL connection from Excel to the SQL database to extract data. We then manually copy the data into the GANTT spreadsheet. We are trying to find a way that we can select the Pivot Table and click Refresh Data and it also updates the GANTT Chart.
July 31st, 2017 - 10:33
I chanced upon your software and downloaded to use the Gantt Chart template to you. I kind of like it but the file size seem to be very large for an Excel without images. It’s about 35MB per file and it’s causing a lag when doing certain task. It there a way to reduce the file size significantly? Else it’s hard for me to decide on using it and introducing it to my colleagues.
Hope to hear from you.
August 6th, 2014 - 14:22
This is in reference to the Project Manage Gantt chart template. When I add this template as an excel webpart to a sharepoint page, the formatting on the scrolling dates bar is no longer available and the dates aren’t readable, otherwise the chart works great. I have unprotected the sheet and removed all validation data. I can open in excel and the dates bar formatting is there so it appears to be tied to the excel webpart. Any ideas? Thank you for your help.
August 12th, 2014 - 12:13
Hi Sandy,
I’m afraid it wasn’t designed with SharePoint webparts in mind.
Have a read of this: http://office.microsoft.com/en-gb/sharepoint-server-help/differences-between-using-a-workbook-in-excel-and-excel-services-HA010105457.aspx
As you can see, certain elements I’ve incorporated, like forms controls and rotated text, are not necessarily supported in Excel Services.
You could remove the scroll bar and manually change the DateOffset in the settings worksheet (or link that to a cell on the gantt worksheet), and reformat the dates to get something that works for you.