Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 15th 05, 01:41 PM
Nodak
 
Posts: n/a
Default Formula related Crash on Opening File


I have a Spreadsheet that "crashes" on opening, I am trying to understand
why and if I can avoid creating similar problems in the futute.

It is has quite a few Sumproduct, Sumif & Vlookup formulas. But does not
refer to other files, all data is in this file. file is ~20 MB

When I turn to manual calsc and do not "calc" on save I am able to call the
file up.
I think the problem may be formula related. Also If I "range Value: the
file there is no issue on opening.

Are there any guideline or utilities to tell you when you are reaching
"boundaries in Excel

I am on XP, Excel 2002 SP-2.

Any thoughts would be appeciated. ..Thanks






Reply
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
Problem with opening an Excel - File Roland S. Excel Worksheet Functions 0 June 9th 05 10:37 AM
Opening a file in a macro (network) David P. Excel Discussion (Misc queries) 3 June 8th 05 12:35 AM
Opening a file with code without a set file name jenkinspat Excel Discussion (Misc queries) 1 March 2nd 05 03:39 PM
opening file problem please help Steve Goodrich Excel Discussion (Misc queries) 2 March 1st 05 10:40 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017