ProfessionalExcel.com In the office, Excel is a way of life… not just a tool

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

Comments (4) Trackbacks (0)
  1. 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.

  2. 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.

  3. 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.


Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Trackbacks are disabled.