Meaning of message

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

When I try to open an excel file created in Excel 97 on a
machine running Office 2000, I get the following message:

"This workbook contains one or more external data ranges
whose column sorting, filtering, and layout changes are no
longer being retained.
To start retaining these changes, click OK, and then ckick
Refresh data on the external Data toolbar."

Can anyone tell me what this all means? I am haveing a
problem with this worksheet and this may be related.
 
Hi
sounds like you have used 'Data - Import - External Data' in this
workbook. Maybe the data source is no longer available?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

External Data Toolbar permanently greyed out. 7
Link behavior with changing data set 3
External Data Refresh Issues 0
How to save the setting on displayi toolbar for refresh external d 4
Where are the links to other data sources? 1
External Data Warning Message - I have No External Data in wrkbk 0
Refresh order when refreshing all in a workbook 1
Problems Obtaining Data 2

Back
Top