I
I need help please
*Using Excel 2007 macro-embedded file (.xlsm), Importing from Access 2007
(.accdb) files*
I need to include data from between 1 and 10 access databases, and compile
the data into 1 worksheet. The data from Access increases daily (new rows).
When I try to refresh the data, it pops up with:
This operation is not allowed. The operation is attempting to shift cells
in a table on your worksheet.
Under External Data Properties, there are 3 options under:
If the number of rows in the data range changes upon refresh:
--Insert cells for new data, delete unused cells
--Insert entire rows for new data, clear unused cells
--Overwrite existing cells with new data, clear unused cells
I have tried each of those options, but get the same error each time. This
is not a problem on worksheets that only need to import 1 data source.
I really MUST have one worksheet with this compiled information from 3
sources (for this project). Any suggestions?
(.accdb) files*
I need to include data from between 1 and 10 access databases, and compile
the data into 1 worksheet. The data from Access increases daily (new rows).
When I try to refresh the data, it pops up with:
This operation is not allowed. The operation is attempting to shift cells
in a table on your worksheet.
Under External Data Properties, there are 3 options under:
If the number of rows in the data range changes upon refresh:
--Insert cells for new data, delete unused cells
--Insert entire rows for new data, clear unused cells
--Overwrite existing cells with new data, clear unused cells
I have tried each of those options, but get the same error each time. This
is not a problem on worksheets that only need to import 1 data source.
I really MUST have one worksheet with this compiled information from 3
sources (for this project). Any suggestions?