Excel (2003) crashes when referencing to external workbook in freezeframe
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. |
All times are GMT +1. The time now is 06:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com