dmacmillan
Board Regular
- Joined
- Apr 5, 2004
- Messages
- 125
Hello All,
I have an 11MB workbook in "xlb" file format.
File functions fairly well (full calculation rebuild takes approx. 4 seconds) but becomes completely unresponsive when a specific sheet is selected, and Excel must be closed in Task Manager.
This particular sheet contains a graph between outline grouping. The waterfall graph is a grouping of: chart object; text box; shape; and a copied picture (of a cell value with symbol).
Can select the sheet in the browser, but that version will not interact with a grouped chart object.
Prefer not to delete the sheet in the browser, as it also contains numerous calculations.
Would be grateful for recommendations.
Hopefully I have made myself clear.
Many thanks,
David
I have an 11MB workbook in "xlb" file format.
File functions fairly well (full calculation rebuild takes approx. 4 seconds) but becomes completely unresponsive when a specific sheet is selected, and Excel must be closed in Task Manager.
This particular sheet contains a graph between outline grouping. The waterfall graph is a grouping of: chart object; text box; shape; and a copied picture (of a cell value with symbol).
Can select the sheet in the browser, but that version will not interact with a grouped chart object.
Prefer not to delete the sheet in the browser, as it also contains numerous calculations.
Would be grateful for recommendations.
Hopefully I have made myself clear.
Many thanks,
David
