Hi,

If I share an excel 2002 workbook the active cell at the time of sharing becomes fixed. You can enter data in different cells on different sheets however when you save and re-open the workbook it will default back to cell that was active when the workbook was orginally shared.

Does anyone know how to prevent this? Is this unique to our installation or is this common in Excel 2002?

I would prefer no macro solutions as individuals in my organisation cannot face the complexity of macro settings!

Many thanks.