ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can a workbook with macros created in excel 2003 work in excel 20. (https://www.excelbanter.com/excel-discussion-misc-queries/2548-can-workbook-macros-created-excel-2003-work-excel-20-a.html)

Steve Venti

can a workbook with macros created in excel 2003 work in excel 20.
 
I created a workbook in excel 2003. I then made changes to it on another
computer using excel 2000 and saved it to a CD. When I open the file up in
excel 2003 I get a message that says "data may be lost". When it does open
all the macros are lost.
Are ther limitations working between excel 2000 and 2003?


Don Guillett

I suspect that your problem is not the version difference but is due to the
fact that you saved it to a cd. Never save a file to a cd or floppy. Always
save the file on the HD and then COPY to the cd. Then, copy from the cd to
the HD and then open from the HD.

However, there may be version differences too, depending on what you are
doing. When in doubt always create in the lower version which will work on
the later version.

--
Don Guillett
SalesAid Software

"Steve Venti" <Steve
wrote in message
...
I created a workbook in excel 2003. I then made changes to it on another
computer using excel 2000 and saved it to a CD. When I open the file up in
excel 2003 I get a message that says "data may be lost". When it does open
all the macros are lost.
Are ther limitations working between excel 2000 and 2003?




Frank Kabel

Hi Steve
you should have no problems switching between Excel 2000 and Excel 2003

"Steve Venti" wrote:

I created a workbook in excel 2003. I then made changes to it on another
computer using excel 2000 and saved it to a CD. When I open the file up in
excel 2003 I get a message that says "data may be lost". When it does open
all the macros are lost.
Are ther limitations working between excel 2000 and 2003?



All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com