Error: Cannot expand named range

  • Thread starter Thread starter Patty
  • Start date Start date
P

Patty

I have created and linked an Access form to do data entry
on my Excel spreadsheet. Once I get passed a few records
I get the cannot expand named range error. In the
spreadsheet I had up to 4 records, but when I click on the
View MS Form Button, I will only see 2 records. What
causes this and how do I fix it?
 
How do I find that out? I have never linked an access
form, so I just followed the steps in the book and it
created the link for me. I assume that the range was
somehow created with the link.
 
I have located where the range is if I go to Insert, Name,
Define. The problem is that when I enter records into the
Access form, it is updating the spreadsheet but not the
range...how do I do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot Expand Named Range - when size of the Range exceeds 1
Delete Hidden Named Range 3
cannot expand named range 1
Can't located named range 3
Cannot expand named range. 1
Cannot Expand Named Range 2
Using Query and expanding named ranges 1
Name & chart problem 2

Back
Top