M
Mald
From 12 crosstabs I have created spreadsheets in Excel by selecting TOOLS - Office Links - Analyze It with MS Excel.
To refresh these spreadsheets I view individual Crosstabs and then repeat TOOLS - Office Links etc and this then refreshes the spreadsheet. (irrespective of the number of records)
I have then set up a macro to try and refresh the sheets I was unable to select the opperation above so from the Objects menu and NEW. I have then selected TransferSpreadsheet, setting Transfer Type to link. Setting up a line for each crosstab.
This ran fine on test with a few records but baulks at the 4000 records I tried to throw at it. Returning an error of too many fields. Other than some heavy scripting is there any way round this?
To refresh these spreadsheets I view individual Crosstabs and then repeat TOOLS - Office Links etc and this then refreshes the spreadsheet. (irrespective of the number of records)
I have then set up a macro to try and refresh the sheets I was unable to select the opperation above so from the Objects menu and NEW. I have then selected TransferSpreadsheet, setting Transfer Type to link. Setting up a line for each crosstab.
This ran fine on test with a few records but baulks at the 4000 records I tried to throw at it. Returning an error of too many fields. Other than some heavy scripting is there any way round this?