Hi Sergio

When I run the sp it never finishes, so I have been terminating it with task manager and get the error :-

Msg 6522, Level 16, State 1, Procedure up_excel_pivot_refreshtable,...

Hi Sergio

Next Problem

I ran the sp and got an error message:

(1 row(s) affected)

Msg 6522, Level 16, State 1, Procedure up_excel_pivot_refreshtable, Line 0

A .NET Framework error occurred during execution of user-defined...

Hi Sergio

Thanks trying it out

Hi Sergio

Nearly there....I found this a bit difficult, I'm using Office 2007 & Visual Studio 2008 ...but just stuck on the last page now..

I have a Sp called up_excel_pivot_refreshtable, however,...

Hi

I have change the source dataset to a temp table instead of a view and it is now refreshing 5 out of the 12 spreadsheets before hanging....so some progress. ...

Hi

I tried this but still no joy :crying:

Thanks any way for your help

Regards

Susannah

Hi

I get the same result in the SSIS package or just running it from query editor

exec dbo.USP_DMO_Excel_Pivot_RefreshTable

@FileName = 'C:\GRS\EPG_ContactProfiling\EPGContactDQAnalysis_V2.xlsx',

@WorksheetIndex = 1,

@PivotTableName = 'PivotTable1',

...

Hi Sergio the Life Saver

Hope you can help me again 🙂

I am using your sp , however, I only seem to be able to refresh around 2.5k records and...

Hi

Just wanted to say thanks ..your solution saved my life..I spent 2 days trying to sort it out before I found it 🙂