Hi everyone - weird problem encountered & would like some feedback.
I am building a dashboard that incorporates a 3 x 6 text box grid (regular grid tool won't match the current style formating). The sources for the text boxes are a dynamic vlookup formula of a very small area.
Here is my problem. The minute I link any of the text boxes to the spreadsheet, my file jumps from 2.5 MB to over 40 MB!
What is also weird is that I have not set any dynamic visibility rules for the grid to display yet. Also, when I delete the text boxes, it doesn't return the XLF to it's original size - it remains over 40MB.
I orginally thought my XLF was corrupted, so I cleared the data sources, and confirmed the file growth problem is linked to the cell targeting somehow. My Excel 2003 spreadsheet is not XML linked, so there is no dynamic data dumping, and I am pre-aggreating the data before adding it into the spreasheet. There are no outside dynamic feeds - all data is static. The spreadsheet size is tiny (about 150 KB), and I have deleted all of the blank rows & columns, as well as any named ranges, so it's as light as it is going to get. I have XP SP3 if that matters.
I have also applied all of the hotfixes listed on the site, and this is the full product, not a demo.
Has anyone else seem this problem before?
Edited by: Michael Dyne on Feb 20, 2009 5:33 PM