This table contains cells that are outside the range of cells defined in this spreadsheet error 2950

[tntberol]

I received the above error when using a Macro to import from Excel. I have been doing this same thing bi-weekly for years. Nothing has changed. I used this same function earlier in the day to import a selection of excel cells and it worked fine. I have "saved as" both the access database and the excel spreadsheet and tried to import the same data that worked earlier in the day, I have also done the compact and repair database and none of that works.

Any Ideas?

 

[Micron]

Nothing has changed

If that's really true, the only thing I've ever read on the error is that the spreadsheet file might be corrupt. Try copying the data into a new workbook. If I was a betting person, I'd lean more towards someone has changed something and you're not aware of it or are not considering any change as significant. Some connection types require that the range have data in every header row and column, so any header deletion or column removal could be problematic. That's all I know on the subject.

 

[tntberol]

Thank you so much for your help. I copied the excel data to a new spreadsheet (instead of Save As) and it worked perfectly. The spreadsheet must have been corrupt. Thank you! Thank you! Thank you!

 

[Micron]

AWESOME!