ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Error on Refresh Data Import from Access (https://www.excelbanter.com/excel-discussion-misc-queries/175491-error-refresh-data-import-access.html)

2+2=5?

Error on Refresh Data Import from Access
 
I have a spreadsheet pulling data from 3 different access databases, set to
automatically update on spreadsheet open. When I attempt to open/refresh the
data I get the following error:
"This operation is not allowed. The operation is attempting to shift cells
in a table on your worksheet."
This message seems to be tied to single-value(Cell) imported data, but does
not occur for those imports that pull multiple values(Rows&Columns). Any
ideas on how to overcome this error would be appreciated!


All times are GMT +1. The time now is 02:22 PM.

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