[Last Call] Learn how to a build a cloud-first strategyRegister Now


Excel 2003 spreadsheets not opening in Excel 2007

Posted on 2009-12-30
Medium Priority
Last Modified: 2013-11-27
I have a number of excel spreadsheets that were created in Excel 2003.
They contain queries relating back to my application SQL database. The queries work fine in Excel 2003 and I dont have a problem there.
The problem is when I try to open the file in Excel 2007 it crashes while opening with the "Excel has encountered a problem...." error.
If I copy the SQL from the 2003 query, open a new query in 2007 and copy and paste the data it works fine and refreshes without a problem, but I dont really want to do this for all my queries that I have for this database!
The SQL for the query is like the below, minor adjustments for each query just relating to the table it is looking at. I have tried unticking all the tick boxes in 2003 relating to the query properties. I am at my wits end as I know there isnt any problem with the query but there is something 2007 doesnt like :(

SELECT dhc_contractrenewals.BoatName, dhc_contractrenewals.StartDate, dhc_contractrenewals.EndDate, dhc_contractrenewals.FeeType, dhc_contractrenewals.FeeCode, dhc_contractrenewals.Confirmed, dhc_contractrenewals.Declined, dhc_contractrenewals.Custname, dhc_contractrenewals.ContractNo, dhc_contractrenewals.Tel_Home, dhc_contractrenewals.Tel_Mobile, dhc_contractrenewals.Tel_Business, dhc_contractrenewals.e_Mail, dhc_contractrenewals.Renewal
FROM CH_Live_M3.dbo.dhc_contractrenewals dhc_contractrenewals
WHERE (dhc_contractrenewals.StartDate={ts '2009-12-01 00:00:00'}) AND (dhc_contractrenewals.Renewal>1) AND (dhc_contractrenewals.FeeCode In ('12monthly 09/10','Loyalty 09/10','SBO 09/10','SBOloyalty09/10'))
Question by:merronm
1 Comment
LVL 38

Accepted Solution

puppydogbuddy earned 2000 total points
ID: 26151810
If you have not updated to Office Suite Service Release 2 you should do so.   I seem to recall that there were a number of bug fixes to Access and Excel in the update.....but  the update should be installed irregardless of whether or not it fixes your specific problem.


Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question