ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2000 to Excel 97 (https://www.excelbanter.com/excel-discussion-misc-queries/30493-excel-2000-excel-97-a.html)

frankie

Excel 2000 to Excel 97
 
I have Excel 2000 at home and Excel 97 at work. When I make a workbook or
worksheet at home and then take it to work, I am unable to make or add
changes to worksheet at work, but i can at home,
anyone know how to fix this?????thanks


Don Guillett

If just saved as an excel workbook instead of some specific then it should
work except for features available in 2000 that may not be available in 97.

--
Don Guillett
SalesAid Software

"frankie" wrote in message
...
I have Excel 2000 at home and Excel 97 at work. When I make a workbook or
worksheet at home and then take it to work, I am unable to make or add
changes to worksheet at work, but i can at home,
anyone know how to fix this?????thanks




Dave Peterson

And if you're writing about making changes to the VBA code, then make sure you
keep the project unprotected.

xl97 can't view the code if was protected in xl2k (or higher).



frankie wrote:

I have Excel 2000 at home and Excel 97 at work. When I make a workbook or
worksheet at home and then take it to work, I am unable to make or add
changes to worksheet at work, but i can at home,
anyone know how to fix this?????thanks


--

Dave Peterson


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

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