[resolved] Cannot read name ranges Error

One Star

[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.

Accepted Solutions
One Star

Re: [resolved] Cannot read name ranges Error

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.

All Replies
One Star

Re: [resolved] Cannot read name ranges Error

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.
One Star

Re: [resolved] Cannot read name ranges Error

workbook?
One Star

Re: [resolved] Cannot read name ranges Error

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?
One Star

Re: [resolved] Cannot read name ranges Error

workbook?

Open de excel file and pres ctrl+F3
One Star

Re: [resolved] Cannot read name ranges Error

It worked for me ! thanks