<internal error> Problem when writing table...
I've seen others try to resolve this issue by checking the SAPBEXQUERIES page to make sure the tables don't exceed a certain number of rows. I've checked and the max row on SAPBEXQUERIES and it is 1002 (cell IR1002 to be more exacting).
Anyway, the table is normally C_T_VARIABLES but I get problems with others as well.
I've tried to rebuild the file from the ground up by creating a new document and embedding all 10 queries into it, per the original file... When I refresh this new workbook, the problem disappears but as I work to embed the graphs, cells formulas, cell formats (etc) and additional pages that consume the queries, the problem is reintroduced. So one would surmise perhaps that a cell format (before i try to rebuild the graphs) is the cause... Perhaps there is a format that is illegal.
Of course, this rebuilding effort takes place in code.
But in this rather than doing a copy/paste, I scour each element of source book then recreate it in the new workbook WITHOUT doing a copy/paste. I dwell on NOT using copy/paste because experience has taught when doing copy/paste, extra workbook baggage is transferred from one workbook to another especially when, for example two of more graphs are to be copied simultaneously
Tables that cause me grief are:
Appreciate any help you can muster... Thanks.