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!