ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I cannot refresh all of the queries in my spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/101170-i-cannot-refresh-all-queries-my-spreadsheet.html)

Peter

I cannot refresh all of the queries in my spreadsheet
 
I have a spreadsheet which has 20 worksheets in it and each sheet contains
around 10 queries from an Access database. However, when I use the 'Refresh
All' funtion I get the following error message "[Microsoft][ODBC Microsoft
Access Driver]Cannot open any more databases".

I created a macro which refresh the queries on one worksheet at a time, but
after the running the macro on the forth the sheet the same error message
appeared.

Does anyone know how I can refresh the queries in my spreadsheet or have I
simply exeeded the number of Access queries that an Excel worksheet can
handle?


All times are GMT +1. The time now is 08:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com