Microsoft excel 2000

I have a large workbook on Excel 2000. When I have the autosave on, Excel goes to sheet 1 upon autosaving. Is there some solution to stop this from repeating? Thanks Guy/s.