A
Andy Powell
senario:-
I create a new excel sheet which contains 3 worksheets.
On sheet1 cell A1 contains the text test and cell A3 also
contains the text test. On sheet2 cell A1 contains text
fff and on sheet3 cell A1 contains the text ggg.
If I now right click on any of the sheet tabs in the
bottom left corner of the screen and choose "Select All
Sheets" then click on Edit, Find.
In the Find What box type in test. Click on Options, and
change the "Within" drop down to "Workbook" now click
on "Find Next", (this then finds the first instance)
click "Find Next" again, (this then finds the second
instance), click "Find Next" again and Excel gets stuck in
what looks like a loop and hangs the system.
There appears to be a workaround by performing the search
in a different way but this appears to be a bug dare I say
it in the application.
All info would be useful. Thanks Andy
I create a new excel sheet which contains 3 worksheets.
On sheet1 cell A1 contains the text test and cell A3 also
contains the text test. On sheet2 cell A1 contains text
fff and on sheet3 cell A1 contains the text ggg.
If I now right click on any of the sheet tabs in the
bottom left corner of the screen and choose "Select All
Sheets" then click on Edit, Find.
In the Find What box type in test. Click on Options, and
change the "Within" drop down to "Workbook" now click
on "Find Next", (this then finds the first instance)
click "Find Next" again, (this then finds the second
instance), click "Find Next" again and Excel gets stuck in
what looks like a loop and hangs the system.
There appears to be a workaround by performing the search
in a different way but this appears to be a bug dare I say
it in the application.
All info would be useful. Thanks Andy