Sign Up for Training |
Jet Global Company Site
Submit a Request
Give Feedback

The given key was not present in the dictionary

Issue :
When running a report, the error "The given key was not present in the dictionary" is displayed.
Resolution :
Jet caches certain information about the table structure, unique identifiers, and fields available in your data source when a Data Source Connection is first accessed.  When that information is changed (for example: a new primary key is defined), the cache needs to be refreshed.
Restart Excel and then reload your report.
Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request