How to open .xlt containing PivotTable?

H

hstijnen

Hi,
I've an Excel template MySheet.xlt containing a pivot table based on a query
exported from Access. In VBA I open the template:

Set appExcel = CreateObject("Excel.Application")
Set wbk = appExcel.Workbooks.Open(MySheet.xlt)

And I get MySheet1.xls. So far OK. But the pivot table is not updated and
trying to update it manually, gives an error: Invalid Pivot Table.
However, when I open the sheet by double clicking the xlt the pivot table is
updated, and all is OK.

How can I realize that in VBA?
Application.FollowHyperlink MySheet.xlt
opens the xlt directly

Thanks for help
Henk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to open .xlt containing pivot table? 0
How do you capture the name of the current worksheet in VBA? 12
Open file with a Pivottable Protected 0
Corrupt files due to pivot remnants after saving via VBA 0
Open XLT for edit and set Addin to False 1
How to open .xlt in VBA? 3
How to maintain dynamic data range for Excel PivotTable 4
How do I modify a SQL connection string in an xlt file from a VB6 app? 2

Top