Sharon Hague
Registered User.
- Local time
- Today, 01:24
- Joined
- Jul 10, 2003
- Messages
- 138
Hi All
I have a spreadsheet which I refresh data on which is stored on our accounts package. I do this using ODBC.
I want to insert subtotals into the spreadsheet which I can do, however when I go to refresh the data again the subtotals dissapear and I have to insert them again.
Is there any way I can tell the spreadsheet not to delete the existing subtotals and for it to work out the new ones with the refreshed data?
I'd appreciate anybody's help on this.
I have a spreadsheet which I refresh data on which is stored on our accounts package. I do this using ODBC.
I want to insert subtotals into the spreadsheet which I can do, however when I go to refresh the data again the subtotals dissapear and I have to insert them again.
Is there any way I can tell the spreadsheet not to delete the existing subtotals and for it to work out the new ones with the refreshed data?
I'd appreciate anybody's help on this.