F
Fao, Sean
I have an Excel 2007 spreadsheet, which is hosted on a SharePoint 2007
server and accessed through the SharePoint Excel Web Access WebPart. On
a 2nd worksheet, I have a range defined, which displays the results of a
UDF that returns an object array. This portion functions correctly. On
the 1st worksheet, I have a pivot table, which uses the named range
from the 2nd worksheet as its data source. This doesn't work. All that
the pivot table renders is a single line with no data. I have verified
that the pivot table is configured to refresh upon opening the spreadsheet.
Interestingly enough, if I add yet a third tab to the spreadsheet, which
contains static data, I have no issues. The steps I took to create the
pivot table are identical. The only thing that is different is the
dynamic nature of the UDF data versus the static nature of the data I
entered into the 3rd tab.
Any thoughts on what might be causing this?
Any help would be greatly appreciated and I thank you in advance,
server and accessed through the SharePoint Excel Web Access WebPart. On
a 2nd worksheet, I have a range defined, which displays the results of a
UDF that returns an object array. This portion functions correctly. On
the 1st worksheet, I have a pivot table, which uses the named range
from the 2nd worksheet as its data source. This doesn't work. All that
the pivot table renders is a single line with no data. I have verified
that the pivot table is configured to refresh upon opening the spreadsheet.
Interestingly enough, if I add yet a third tab to the spreadsheet, which
contains static data, I have no issues. The steps I took to create the
pivot table are identical. The only thing that is different is the
dynamic nature of the UDF data versus the static nature of the data I
entered into the 3rd tab.
Any thoughts on what might be causing this?
Any help would be greatly appreciated and I thank you in advance,