Joined: 01 Apr 2004
Location: Wageningen Netherlands
|Posted: Sat Apr 03, 2004 7:46 am Post subject: sheets missing after saving with filter on
|when i open my .xls file it only shows one sheet of the 7. at first i had no problems opening that file. No i only can shee one sheet. At the bottom of the screen OO tells me this sheet is nr 6 out of 7. so OO does remember the sheets. If i hide the current sheet with sheet -> hide. i get the next sheet and i can see them all in this way. When i then save the file and open it again it opens with al sheets visible at the "toggle sheets bar" but when i toggle, this bar suddenly disappears and i cant move around anymore. I think its a problem when saving while "filter" is on, via data -> filter -> autofilter . Its not a problem with my OO, because other files with several sheets open normally. i put off filter and save it put it doesnt fix the problem.
i already tried it saving in OO format. I can get 6/7 sheets back and when i open the last problem one, my " toggle sheets bar" disappear again but the sheet itself opens
i work on w98 and the file is made in OO.
can someone help me please ?
if you need more info just post