Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Refresh Issues when linking Access queries to Excel | Excel Discussion (Misc queries) | |||
Ridirect & Refresh data from access database | Excel Discussion (Misc queries) | |||
How do i refresh external data import in excel in seconds | New Users to Excel | |||
"Refresh All" won't work with external Access data located on serv | Links and Linking in Excel | |||
Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors | Excel Discussion (Misc queries) |