I am have a series of moderately complicated charts to export. XL Toolbox is great, but after I export about three or four of the graphs, I start to get one of a couple similar errors: unable to create bitmap or unable to load bitmap. I’ve also received an out-of-memory error. Note that I have 32 GB of memory and have 25 GB free when exporting.
To work around the problem, I can exit Excel and restart it. Simply closing the worksheet does not work. With this process, I export two to six graphs at a time. This works OK, given I have just 18 of them, but it does get tiresome when I need to make a small change and export them all over again. Does anyone know of a fix or more convenient workaround?
I’m using the latest version of Daniel’s XL Toolbox (7.2.13) and exporting PNG, 600 dpi, grays, transparent canvas. I get the same error with TIFFs, RGB, what or transparent white canvas. I’m using Office Professional Plus 2010 with the latest patches and updates.