ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Refreshing Workbook Connections with Access (https://www.excelbanter.com/excel-discussion-misc-queries/225652-refreshing-workbook-connections-access.html)

Jack PDX

Refreshing Workbook Connections with Access
 
In Excel, I have workbook connections set up to import data from Access
tables and queries. Whenever I 'refresh' those connections, I get an
(un-numbered) error message as follows: "This operation is not allowed. The
operation is attempting to shift cells in a table on your worksheet."

My understanding is that these connections should readily refresh. Right
now, each time I want to refresh the connections, I must recreate the
connections from scratch. Any ideas about how to resolve this issue?


All times are GMT +1. The time now is 06:45 AM.

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