Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting External Data based on criteria insde of the external data | Excel Discussion (Misc queries) | |||
Security Warning Message Bar to update External Links in Excel 200 | Excel Worksheet Functions | |||
updating external data sheet causes loss of data on linked pages | Excel Worksheet Functions | |||
external data error message | Excel Discussion (Misc queries) | |||
External Data Queries - Data Range Properties v Spreadsheet Format | Excel Discussion (Misc queries) |