Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
JimmyM
Contributor
Contributor

[resolved] Cannot read name ranges Error

I'm using Talend Enterprise Data Integration Team edition v5.0.2.
I have a few jobs that have SQLServer, Excel Spreadsheet, and MS Access inputs as well as Oracle and Excel outputs.
I'm getting the below error, but can't seem to track down its source. The job appears to run as expected.
Warning: Cannot read name ranges for _FilterDatabase - setting to empty
What might typically cause something like this so I can start looking in the right place at least.
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable

I think the most likely candidate is Excel. If you open the workbook and hit Ctrl + F3 you should see a list of named ranges. They me be used somewhere else in the workbook, either in formulas or charts.

View solution in original post

5 Replies
Anonymous
Not applicable

I think the most likely candidate is Excel. If you open the workbook and hit Ctrl + F3 you should see a list of named ranges. They me be used somewhere else in the workbook, either in formulas or charts.
Anonymous
Not applicable

workbook?
Anonymous
Not applicable

I have the same problem with extra name ranges. However, I need these named ranges for my spreadsheet to function properly. So, is there a way to suppress these warnings?
_AnonymousUser
Specialist III
Specialist III

workbook?

Open de excel file and pres ctrl+F3
_AnonymousUser
Specialist III
Specialist III

It worked for me ! thanks