Is there anyone out there that can help me?

T

Tom

Thank you for reviewing this!

I have created a pivot table/chart workbook that I need
to save as a template. The source data is local without
any external links. However, when I save the workbook as
a template file, it asks the following question regarding
external data:

"This workbook contains external data. Do you want MS
Office Excel to clear the data before saving the
template, and then automatically refresh the data
whenever the template is opened?"

Is this standard XL logic for a pivot table template even
when there is no external data and is there a way to
eliminate having the msg show up?

Thanks,
Tom
 
I

Inbar

The Pivot "External data" is coming from the worksheet. So, yes, this is
Excel default behavior. You cannot disable it when saving the template, but
you can disable it from the xlt by answering "yes".
 

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

Does this make sense? 0
Why do charts disappear? 3
Refreshing external data on individual sheets in a specific sequen 1
query to external data 3
empty data from a pivot table 0
Importing Data to a Template 0
Query Problem with Read-Only Workbook 0
Used Range and Source data of a Pivot Table 1

Top