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.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.