Forum Discussion
How do I have Excel treat each file separately - for search, undo, etc.
I thought I had wrapped this up by saying that the option to start independent instances of Excel by using the /X startup option is my solution. This makes each file independent with separate undo and find/replace boxes. But, I did not see that this morning when MS asked me to indicate the best solution. mathetes
Thanks, I will make a suggestion but it is very annoying and I wonder why no one else has complained. While it might make some sense to replace all across files, although I have never tried it. Even worse is when you undo and it does it across files. That is very bad.
djc2002us Oh it gets better!!! Here is a bug I reported a while ago and still exists.
Open 2 workbooks
in workbook 1 do a search for something in it (anything that exists or type something and then use ctrl-f to find it)
then click directly into the formula bar of workbook 2
type something in and press enter
and watch it go into workbook 1
It is a little confusing to follow but do the above steps exactly and you will see how bizarre it is.
Basically I was working in a workbook needing to make updates from another workbook. I would search and find the cell/information I needed and when I would go to type the new info into the new workbook it was going into the wrong workbook. This seems like a pretty normal thing I can't believe more people haven't had this issue. In any case, discovered and reported this bug years ago and still hasn't been fixed.