Reply to thread

Message: [QUOTE="klav, post: 6372855"] I have an excel spreadsheet (called "2009info") that is linked to an Access database and I'm opening this spreadsheet with a macro (this macro is pulling data from various spreadsheets and this is only one of them). Even though the spreadsheet "2009info" is set up to refresh upon opening, it does not refresh unless I manually select the refresh button. So I thought I'd use the following command in my macro to do the refresh: ActiveWorkbook.RefreshAll This command works when I step through the macro but does not work when I simply generate the entire macro. Does anyone know why this would be happening and what can I do to get around this? [/QUOTE]