Forum Discussion
=Excel.CurrentWorkbook()
How work this function? =Excel.CurrentWorkbook() Which is current workbook? I always got emtpy fields Do i need specify any workbook name and path? Do it take everithing from Activeworkbook?
Hi
I do this on my desktop PC and use two options:
The one is a table and the other a named range as source.
They both work on my local machine.
When I upload to SharePoint and Refresh All, the table based one works perfectly, but the named range based one give "key do not match any rows in the table error.
I open the file obviously using Excel For the Web.
Why is it able to use table and range name as source on my esktop, but on the weg, it gives error with the named range version?
Totally in the dark here....