D
dmkAlex
This is a problem in Excel 2003. Not sure it exists in later version.
Scenerio:
In sheet1 of book1, the frame was frozen (freeze frame) to see the top
rows.
In sheet1 of book2, there is no freeze frame.
Write any formula in sheet1, book1 that references sheet1 of book2
will cause Excel to crash.
Work around:
Un-freeze frame in sheet1 of book1 before writing the referencing
formula.
Or, freeze a frame in sheet1 of book2 before writing the formula in
book1.
The key is, both sheets (the originating sheet and the destination
sheet in the external book) must be synchronized that both are frame
frozen, or both unfrozen.
I cannot find any reference searching the internet so I am posting
this for other.
Can someone having subsequent version try this and see if MS has fixed
this bug?
Thanks.
Scenerio:
In sheet1 of book1, the frame was frozen (freeze frame) to see the top
rows.
In sheet1 of book2, there is no freeze frame.
Write any formula in sheet1, book1 that references sheet1 of book2
will cause Excel to crash.
Work around:
Un-freeze frame in sheet1 of book1 before writing the referencing
formula.
Or, freeze a frame in sheet1 of book2 before writing the formula in
book1.
The key is, both sheets (the originating sheet and the destination
sheet in the external book) must be synchronized that both are frame
frozen, or both unfrozen.
I cannot find any reference searching the internet so I am posting
this for other.
Can someone having subsequent version try this and see if MS has fixed
this bug?
Thanks.