If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
excel versions
I need to develop a MI report in excel. However, the version on my computer is version 2003, but persons who are going to look at it only have version 97. I've tried to create a test sheet on my computer and requested my user, who's got version 97, to open it. As expected, he was not able to open it. Is there anyway I can create the report in 2003 but the file is to be viewable in 97? -- miyuki |
#2
|
|||
|
|||
excel versions
Not sure .. but you could try File Save as,
and select from the "Save as type" box : Microsoft Excel 97 - Excel 2003 & 5.0/95 Workbook.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "miyuki" wrote: I need to develop a MI report in excel. However, the version on my computer is version 2003, but persons who are going to look at it only have version 97. I've tried to create a test sheet on my computer and requested my user, who's got version 97, to open it. As expected, he was not able to open it. Is there anyway I can create the report in 2003 but the file is to be viewable in 97? -- miyuki |
#3
|
|||
|
|||
excel versions
This is not the behavior I'd expect.
The file format for xl97 through xl2003 is the same. Any of these versions of excel should be able to open a file created in any other of these versions. If you emailed the .xls file to the other user, maybe something happened in the transmission. You may want to try zipping the file, emailing it, and have the recipient unzip the file to get to the .xls file. I use www.winzip.com, but there are a lot of free zip (and unzip) programs. miyuki wrote: I need to develop a MI report in excel. However, the version on my computer is version 2003, but persons who are going to look at it only have version 97. I've tried to create a test sheet on my computer and requested my user, who's got version 97, to open it. As expected, he was not able to open it. Is there anyway I can create the report in 2003 but the file is to be viewable in 97? -- miyuki -- Dave Peterson |
#4
|
|||
|
|||
excel versions
Dave Peterson Wrote: This is not the behavior I'd expect. The file format for xl97 through xl2003 is the same. Any of these versions of excel should be able to open a file created in any other of these versions. If you emailed the .xls file to the other user, maybe something happened in the transmission. You may want to try zipping the file, emailing it, and have the recipient unzip the file to get to the .xls file. I use www.winzip.com, but there are a lot of free zip (and unzip) programs. miyuki wrote:- I need to develop a MI report in excel. However, the version on my computer is version 2003, but persons who are going to look at it only have version 97. I've tried to create a test sheet on my computer and requested my user, who's got version 97, to open it. As expected, he was not able to open it. Is there anyway I can create the report in 2003 but the file is to be viewable in 97? -- miyuki- -- Dave Peterson Thanks everyone for the advices. I'll give it a go today. Dave, just wondering. People in our office always have problem with the different versions, especially when using web query, formatting or some macro. Somethings always happen/not happen at all when you open it in version 97. Could this be that it is some settings in our computers which have caused it? -- miyuki |
#5
|
|||
|
|||
excel versions
I don't think you should be seeing errors opening the file. You may experience
errors if your workbook uses code that isn't supported by the earlier version--but that doesn't mean the file won't open. I would expect the same for formatting (although I don't recall any differences for formatting). And I don't use queries enough to answer that portion. miyuki wrote: Dave Peterson Wrote: This is not the behavior I'd expect. The file format for xl97 through xl2003 is the same. Any of these versions of excel should be able to open a file created in any other of these versions. If you emailed the .xls file to the other user, maybe something happened in the transmission. You may want to try zipping the file, emailing it, and have the recipient unzip the file to get to the .xls file. I use www.winzip.com, but there are a lot of free zip (and unzip) programs. miyuki wrote:- I need to develop a MI report in excel. However, the version on my computer is version 2003, but persons who are going to look at it only have version 97. I've tried to create a test sheet on my computer and requested my user, who's got version 97, to open it. As expected, he was not able to open it. Is there anyway I can create the report in 2003 but the file is to be viewable in 97? -- miyuki- -- Dave Peterson Thanks everyone for the advices. I'll give it a go today. Dave, just wondering. People in our office always have problem with the different versions, especially when using web query, formatting or some macro. Somethings always happen/not happen at all when you open it in version 97. Could this be that it is some settings in our computers which have caused it? -- miyuki -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|