Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends,
I appreciate your time. When I try to upload my excel file which has only 2 active sheets called (Full_summary and G_Template(with lot of calculations)) .It is showing many with relevant data when I see the same through QlikView while uploading via File Wizard.
I have attached the image for your reference.Kindly have a look and let me know your valuable feedback!
Best regards,
Kiruthiga
There might be hidden sheets available but I think it's related to PowerPivot/PowerQuery, see:
https://www.google.de/search?q=xlnm+filter+database
- Marcus
Hello Marcus,
Thanks for your time. So I can ignore the _.xlnm_files* right,while loading excel data?
Kindly let me know.
Thank you again!
I think you could just ignore them.
- Marcus
You are absolutely right..,thought of some other logic in mind and totally missed the basic things. My apologies:(
I appreciate your time!