When trying to insert a table linked to an Excel 2010 file, it works up until row 28, however, as soon as I add a 29th row to the table it no longer inserts the table. When I try and insert it, I press ok and nothing happens. I tried inserting it as a smaller table and changing the data link to a bigger range after it was inserted, it just didn't update to a larger range.
Is there a way of getting this to work without having to insert it as two different tables?
This is no answer but you shouldn't have a problem I have inserted tables with over 100 lines, all I can think is there is somthing in the table causeing a problem.
If you want to attach the table I will have a look for you.
Access a broad range of knowledge to help get the most out of your products and services.