Excel 2007 and 2003 conflict.

Prabs · 11-18-2008, 03:11 PM

Hi,

I have an excel file which was originally made in Excel 2003. as the file was big and lot of add-ons were put into it, it started giving error stating “error was detected in the file but excel was able to open the file by making some repairs. Save the file and make the repairs permanently”

Then I pulled out the file when it was fine.

I was advised to use Excel 2007 as it’s a big file and then there will be no problem.

The file is on a share drive.

I open the file in 2007 and it works fine. I can do changes and can save it as xls.

But when the same file is opened in 2003, it gives the same error and some of the values are missing from the file.

Please help!!

ratcat73 · 11-20-2008, 04:06 AM

G'day

I'm going to direct you to some information. Now this information may help you may not or help you to narrow it down the core of the problem.

http://www.decisionmodels.com/memlimits.htm

There is other links just below the heading which maybe helpful

HTH

Prabs · 11-21-2008, 02:39 PM

Thank you very much for your responce. really apperetiated.

the memory is quite ok as its over 1 meg so i dont think that should be a problem but i'll definately go through the other options in the link... see if i can get some more answers for other issues :)

please see if you get anything more in refrence to this

thanks again...

ratcat73 · 11-21-2008, 05:36 PM

Quote:

Originally Posted by Prabs

........
I open the file in 2007 and it works fine. I can do changes and can save it as xls.
.......

Just asking a question.

When in 2007 and you save the file as a .xls.

Do you have the 'Compatibility Checker' activiated ?

Check a workbook for compatibility with earlier versions of Excel

martes · 11-23-2008, 04:17 PM

If you originally had problems in 2003, after saving in 2007 if that overcme the problems, it is hardly surprising that you get problems again when opening in 2003.

You need to address the problems, just upping to 2007 is going to be a transitory fix at best.

Prabs · 11-24-2008, 03:52 PM

Hi Guys, the 'Compatibility Checker' is active.

Sorry for my last post as the memory is over 1gig :)

As I work for an organization and everyone uses 2003.

The first mistake was to load 2007 to get rid of the error.

Now upping to 2007 means a lot of users globally that we will have to change and we cannot do that.

So we actually are stuck... but thank you very much for your response guys, really appreciated.

Please bring in more ideas…

The last thing to do is to upgrade the users to 2007 but I really want to avoid it..

Lest see if we can get a solution for this….

11-18-2008, 03:11 PM	#1 (permalink)
Prabs Registered User Join Date: Nov 2008 Posts: 3 OS: XP	Excel 2007 and 2003 conflict. Hi, I have an excel file which was originally made in Excel 2003. as the file was big and lot of add-ons were put into it, it started giving error stating “error was detected in the file but excel was able to open the file by making some repairs. Save the file and make the repairs permanently” Then I pulled out the file when it was fine. I was advised to use Excel 2007 as it’s a big file and then there will be no problem. The file is on a share drive. I open the file in 2007 and it works fine. I can do changes and can save it as xls. But when the same file is opened in 2003, it gives the same error and some of the values are missing from the file. Please help!!

11-20-2008, 04:06 AM	#2 (permalink)
ratcat73 Registered User Join Date: Oct 2008 Location: Australia Posts: 51 OS: Vista Home Basic	Re: Excel 2007 and 2003 conflict. G'day I'm going to direct you to some information. Now this information may help you may not or help you to narrow it down the core of the problem. http://www.decisionmodels.com/memlimits.htm There is other links just below the heading which maybe helpful HTH

11-21-2008, 02:39 PM	#3 (permalink)
Prabs Registered User Join Date: Nov 2008 Posts: 3 OS: XP	Re: Excel 2007 and 2003 conflict. Thank you very much for your responce. really apperetiated. the memory is quite ok as its over 1 meg so i dont think that should be a problem but i'll definately go through the other options in the link... see if i can get some more answers for other issues :) please see if you get anything more in refrence to this thanks again...

11-23-2008, 04:17 PM	#5 (permalink)
martes Registered User Join Date: Aug 2008 Posts: 21 OS: XP Pro SP2	Re: Excel 2007 and 2003 conflict. If you originally had problems in 2003, after saving in 2007 if that overcme the problems, it is hardly surprising that you get problems again when opening in 2003. You need to address the problems, just upping to 2007 is going to be a transitory fix at best.

11-24-2008, 03:52 PM	#6 (permalink)
Prabs Registered User Join Date: Nov 2008 Posts: 3 OS: XP	Re: Excel 2007 and 2003 conflict. Hi Guys, the 'Compatibility Checker' is active. Sorry for my last post as the memory is over 1gig :) As I work for an organization and everyone uses 2003. The first mistake was to load 2007 to get rid of the error. Now upping to 2007 means a lot of users globally that we will have to change and we cannot do that. So we actually are stuck... but thank you very much for your response guys, really appreciated. Please bring in more ideas… The last thing to do is to upgrade the users to 2007 but I really want to avoid it.. Lest see if we can get a solution for this….