ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   External Data Warning Message - I have No External Data in wrkbk (https://www.excelbanter.com/excel-discussion-misc-queries/263652-external-data-warning-message-i-have-no-external-data-wrkbk.html)

Cass_makeitfun[_2_]

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

I have a question about Microsoft Excel, but I dont think its 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 Im 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 formulas were external. I typed one in myself [=COUNTIF([ @ TIME?],"y"),
and the other formula I used EXCELs 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 cant even save it as my normal file, I had to re-save it as
something else. Now theres 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







All times are GMT +1. The time now is 05:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com