LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Don't understand External Data message

I have an message coming up on an excel template I've created. I don't understand why it ishappening - please help

The template includes

- Data entered by users and standard formula
- A Pivot table that sources data from within the workbook and formats it
- 2 action buttons connected to Macros that are stored within this workbook
- Pictures of logos. They aren't hyperlinked, just copied and pasted in from the Jpeg fil
- Some hyperlinks connected to cells within the template (eg "Check Totals"

I didn't get any refresh messages when the file was just an excel workbook. When I Saved As and changed it to be a "Template", I got a message asking to auto refresh the External Query Data - but I don't have any external data or links in the workbook??

To check this, I did a "Find" on [ to find any external links but there are none
The Macros live within the spreadsheet too (no external names on them)
I even tried to look at Data / Import External Data on the toolbar menu to see if I can access "External Data Properties" but it's greyed out

So I don't understand why I'm getting this message and how to find and get rid of the external data
Does it have anything to do with the Pivot table? Is it safe to say yes to "always refresh it on opening and don't ask the question again" or will user have problems. The template will be used at a different location to me

Any advice or information about this message would be greatly appreciated
BeSmart
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
External Data Warning Message - I have No External Data in wrkbk Cass_makeitfun[_2_] Excel Discussion (Misc queries) 0 May 12th 10 09:02 PM
Getting External Data based on criteria insde of the external data BigMacExcel Excel Discussion (Misc queries) 0 August 31st 09 06:41 PM
I get the message: "The External Table is not in the excpected for Miguel Cervera Excel Discussion (Misc queries) 4 September 25th 08 10:15 AM
Invalid external reference message Laurence Lombard Excel Discussion (Misc queries) 2 November 2nd 07 03:43 PM
external data error message [email protected] Excel Discussion (Misc queries) 0 March 1st 07 07:02 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"