Ron Kochanowski
New Member
Using the template: Gantt Chart Template - by week with completions
Building an array from header styles in Word and transposing it into Excel.
When the transpose inserts the additional rows needed into the Excel Template (renamed MAP Template), the last row of the template week calculations gets a bad value.
Here's a before and after to display what I'm speaking of:
![upload_2014-10-17_13-50-19.png upload_2014-10-17_13-50-19.png](https://chandoo.org/forum/data/attachments/11/11848-cabf56c6f879f79ebdc9f863d5de6806.jpg)
Here the cell calc is accurate.
After the transpose:
![upload_2014-10-17_13-55-59.png upload_2014-10-17_13-55-59.png](https://chandoo.org/forum/data/attachments/11/11850-09df94f28ffc659c4335717cb6157781.jpg)
What was formerly the last row of the table gets a 3 cell references changed to the new end row of the table. It's just this one row that is changed. The remaining rows are generated as they should be.
Any thoughts as to why this happens and how to correct it from re-occurring?
Building an array from header styles in Word and transposing it into Excel.
When the transpose inserts the additional rows needed into the Excel Template (renamed MAP Template), the last row of the template week calculations gets a bad value.
Here's a before and after to display what I'm speaking of:
![upload_2014-10-17_13-50-19.png upload_2014-10-17_13-50-19.png](https://chandoo.org/forum/data/attachments/11/11848-cabf56c6f879f79ebdc9f863d5de6806.jpg)
Here the cell calc is accurate.
After the transpose:
![upload_2014-10-17_13-55-59.png upload_2014-10-17_13-55-59.png](https://chandoo.org/forum/data/attachments/11/11850-09df94f28ffc659c4335717cb6157781.jpg)
What was formerly the last row of the table gets a 3 cell references changed to the new end row of the table. It's just this one row that is changed. The remaining rows are generated as they should be.
Any thoughts as to why this happens and how to correct it from re-occurring?