Prev: Version Upgrade
Next: Pivot Tables 2003 v 2007
From: Cass_makeitfun on 12 May 2010 16:02

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





 | 
Pages: 1
Prev: Version Upgrade
Next: Pivot Tables 2003 v 2007