If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
External Data Warning Message - I have No External Data in wrkbk
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 |
Thread Tools | |
Display Modes | |
|
|