L
Lutash
I have an opened workbook in Excel 07 with my formulas C thru Z. When I copy
and try to paste to a new workbook, it hangs or crashes and the memory usage
goes to over 1g. If I wait thru the hang, then it hangs when I try to insert
or delete any rows. Went to older machine and Excel 03 today to try and
everything worked just fine.
Event viewer gives following error
ID: 1, Application Name: Microsoft Office Excel, Application Version:
12.0.6524.5003, Microsoft Office Version: 12.0.6425.1000. This session lasted
4959 seconds with 900 seconds of active time. This session ended with a
crash.
One of the shorter formulas that i am using
=LOOKUP($U2,{1.1,1.3,1.35,1.56,2,2.15,2.23,2.3,2.35,2.4,2.55,2.58,2.6,2.64,3,3.15,3.2,3.35,3.5,3.55,3.6,3.95,4.1,4.15,4.25,4.35,4.92,5.5,6,6.05,6.2,6.3,12,12.75,13.5,51},{35,18,34,32,1,2,15,3,4,30,16,31,23,25,19,10,24,5,6,12,29,11,17,20,27,7,26,28,8,9,14,22,33,21,37,13})
Can someone please help ?
and try to paste to a new workbook, it hangs or crashes and the memory usage
goes to over 1g. If I wait thru the hang, then it hangs when I try to insert
or delete any rows. Went to older machine and Excel 03 today to try and
everything worked just fine.
Event viewer gives following error
ID: 1, Application Name: Microsoft Office Excel, Application Version:
12.0.6524.5003, Microsoft Office Version: 12.0.6425.1000. This session lasted
4959 seconds with 900 seconds of active time. This session ended with a
crash.
One of the shorter formulas that i am using
=LOOKUP($U2,{1.1,1.3,1.35,1.56,2,2.15,2.23,2.3,2.35,2.4,2.55,2.58,2.6,2.64,3,3.15,3.2,3.35,3.5,3.55,3.6,3.95,4.1,4.15,4.25,4.35,4.92,5.5,6,6.05,6.2,6.3,12,12.75,13.5,51},{35,18,34,32,1,2,15,3,4,30,16,31,23,25,19,10,24,5,6,12,29,11,17,20,27,7,26,28,8,9,14,22,33,21,37,13})
Can someone please help ?