Trust ID PBCEX logo 300x102

Error Message: Cannot expand named range

4 years 1 month ago
Kathryn Grimble
Fresh Boarder
Fresh Boarder
Posts: 2
More
Topic Author
Error Message: Cannot expand named range #6042
I've run into a problem when adding new entries into the database file I've created. It was working without problems but recently started saying "Cannot expand named range" any time I try to add a new entry. It still allows me to print and edit for entries already in my excel file. I attempted to upload a new excel file to see if it was a problem with the number of entries, but it came up with the same error despite the other database only containing 6 entries. Any ideas?
4 years 1 month ago
Craig Bechelli
Administrator
Administrator
Posts: 624
More
Error Message: Cannot expand named range #6047
Hi Kathryn,

It sounds like you are connecting to a range within the Excel spreadsheet rather than the entire sheet.
Can you select the configuration tab and click on database setup, then click next and tell me the view/table name ?

If it has a $ at the end it is the entire sheet, otherwise it is a range of cells that have been defined within Excel itself.

Regards,
Craig

Craig Bechelli
CardExchange Solutions Support Team

"If you define the problem correctly, you almost have the solution." (Steve Jobs)
4 years 1 month ago
Kathryn Grimble
Fresh Boarder
Fresh Boarder
Posts: 2
More
Topic Author
Error Message: Cannot expand named range #6048
Thank you! That was the problem and its up and working again. Thanks so much!
×

Notice

The forum is in read only mode.