excel repair error in 2003

[heedsie]

i have a 2003 excel template where data has been brought in from 2007 via copy and paste into certain cells. it has then been saved into 97-2003. i have then sent it onto someone who has only got excel 2003. when they open it, it shows up as error messages and says something about data to large or something maybe already open. when you click okay it open the document saying something about repairing failed and puts the document in a wierd format and added squares but still has some original writing and all the sheets have lot colours and boxes. when i went onto two computers in my office that have only 2003 excel, one opens it fine with no issue and the other does the same. i have tried alsorts to try and find the problem. i have even downloaded the 2003 converter just incase it was something to do with 2007 but still didnt open. my only thoughts was it maybe a) because data has been copied and pasted from 2007. b)formulas may cause the problem as 2007 formulas but they are basic formulas. it still doesnt explain why it wont open on some but some how opened on a computer in 2003. if anyone has any suggestions it would be really appreciated. thanks

 

[stilesbn]

How many rows and columns are in the data?

 

[heedsie]

lots of data, its has about 18 sheets as it is a bid for contracts but it has 7 years of data which has the 12months in each year. but they have said that there are other documents sent that are bigger and opened fine from others.

 

[stilesbn]

I ask because excel 2003 only allows for 65536 rows where as 2007 allows for 1048576. There is a limit to number of columns too, though the exact number escapes me at the moment.

It's possible that there are too many rows to go from one to the other?

 

[heedsie]

no there isnt that many rows in it, its just strange as it opens on one computer fine but not the others that have 2003 excel, and i even downloaded the conversion software on the none working computer and it still didnt work even though that seem to be the only difference to the working computer to the one that didnt work.