LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
User Defined Function is not working for me in Excel 2007 Abdi Excel Discussion (Misc queries) 1 November 18th 08 10:50 PM
problem with user defined function panjo Excel Discussion (Misc queries) 3 June 16th 06 11:18 AM
User-defined data type; Error: Only User-defined types... tiger_PRM Excel Programming 1 July 18th 04 03:32 PM
User defined type problem R Avery Excel Programming 1 May 26th 04 02:41 PM
User-Defined function not working Guy Gagnon Excel Programming 3 July 14th 03 03:26 AM


All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"