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