Does it open up alright in 2003? If not it just could be that your file has got corrupted somehow?
I never had problems like you did but like Kelly I had faced times when Excel 2007 after opening the file and displaying data and all, warned me that I had to save the file for it to be converted to Excel 2007's format.. Joe ________________________________ From: Kelly Deaver <[email protected]> To: [email protected] Sent: Wednesday, July 8, 2009 10:11:22 PM Subject: Re: Excell data query It is worth a try. Honestly, Office 2007 is pretty buggy. There are a lot of things that the only way I've got them to work is to do a save a the 2003 version of which ever application then do it. I've even set my default for Powerpoint save back to be 2003. Kelly Deaver [email protected] (Yes, I work for BMC. This post reflects the opinions of the poster and not the official opinion of BMC) -------- Original Message -------- Subject: Re: Excell data query From: Steve McDonald <[email protected]> Date: Wed, July 08, 2009 5:45 pm To: [email protected] ** Hi Kelly! Do you mean save a blank workbook as 2003 and then set up the data query? On Wed, Jul 8, 2009 at 3:40 PM, Kelly Deaver <[email protected]> wrote: ** I have seen that. Try saving as Excel 2003 from your 2007 application Kelly Deaver [email protected] (Yes, I work for BMC. This post reflects the opinions of the poster and not the official opinion of BMC) -------- Original Message -------- Subject: Excell data query From: Steve McDonald <[email protected]> Date: Wed, July 08, 2009 5:29 pm To: [email protected] ** Has anyone had problems extracting data via Excel after upgrading to Excel 2007? I have a user that the following error: Unable to obtain a list of tables from the data source. He said spreadsheets created with Excel 2003 work ok but nothing new. We're on 7.1 patch 6 on Unix 10/Informix 10. Thanks ** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
