View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fred fred is offline
external usenet poster
 
Posts: 26
Default Labels in User-Defined Function Not Working Right (First Problem)

---------------
First Problem---
---------------

(Excel 2002 sp3)

A BIG SPREADSHEET
I've created a spreadsheet with 5000 lines and 50 columns.
The file size is 26 megs. Like most of my spreadsheets,
this one has all the formulas copied all the way down to the bottom.

EXCEL CRASHES ON 'CLOSE'
Excel gives me 'faulting module Excel.exe' when I close.
"Send report ........ etc"
This doesn't seem to happen until all my development is done and
I copy down all the formulas. It seems I can load the spreadsheet,
make changes, and save it, but when I shut Excel down I get the error.
This seems to be pretty predictable whenever I do the 'big copy down',
and doesn't happen when it's just 50 columns by 2 rows.

SOLUTIONS TRIED
In searching for a solution, I found suggestions such as:
Delete the toolbar-config XLB files,
uninstall Acrobat 5.0,
install SP3,
try it on other machines (it still happens),
empty the 'Windows temp' folder and reboot
turn off all spyware and virus software
reinstall Excel.....
nothing has worked.
If anyone else knows of solution I'd love to hear it,
but I've spent way too much time on it, and
would be happy with just a workaround. (next post)

Fred