Excel VBA Code.com


 Contents >

Known Excel Problems

1. Sheet Events not working - Application.DisableEvents = False or Memory Issue. Shut down Excel.
2. Corrupted Spreadsheet
3. 50290 Error
4. Slow Spreadsheet
5. Setting an autofilter when they're already set turns them off
6. Error in one place handled incorrectly by if err = ... type test after on error resume next
7. Upper/Lower Case Issues
8. Update Links Problem
9. #Ref
10. Sheet not responding - Application.ScreenUpdating may be set to false
11. Sheet not recalucating - Calculations might be turned off
12. Too slow due to Excel Recalculation
blog comments powered by Disqus


Contact Us

Excel Consulting
987 Shirts
Search Google & Bing