Template file message

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
 

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

Top