External Data Warning Message - I have No External Data in wrkbk


C

Cass_makeitfun

I have a question about Microsoft Excel, but I don’t think it’s an issue to
call into the help desk. I have been working today and yesterday on building
a new template for my SAP Part Tracking Process. I finished it up today by
adding Validation Lists [with names], Pivot Tables, and my regular part
tracking tables. When I went to save it as a template, a message came up:

"THIS WORKBOOK CONTAINS EXTERNAL DATA. DO YOU WANT MICROSOFT OFFICE EXCELTO
CLEAR THE DATA BEFORE SAVING THE TEMPLATE, AND THEN AUTOMATICALLY REFRESH THE
DATA WHENEVER THE TEMPLATE IS OPENED?"

I do not have anything linked from this workbook to an outside source [which
is what I’m assuming external data means]. I tried finding it & correcting it
myself, but all I found that was ‘external’ was in my SAP Part Tracker [and
unissued part tracker] tables’ total row. For some reason it said the total
row formula’s were external. I typed one in myself [=COUNTIF([ @ TIME?],"y"),
and the other formula I used EXCEL’s SUM function to perform. They have both
worked in past Trackers I have used, with the same formulas. What do I do
about this? [I can’t even save it as my normal file, I had to re-save it as
something else. Now there’s 3 files on my desktop and I do not know which is
which]. Why do I keep getting this “External Data†message? It even comes up
in files I have not opened before, or for a long time, that should have all
the data within the workbook.
*It is not always the message above – today is the first time I have
received the message above.

THANK YOU
 
Ad

Advertisements


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


Top