-
Jan 3rd, 2011, 06:59 PM
#1
Speed Up Excel?
I have a book with 18 sheets and a bunch of callculations and it takes 15+ seconds to save changes on exit. What techniques if any can I use to decrease that time?
-
Jan 3rd, 2011, 07:12 PM
#2
Re: Speed Up Excel?
Would decreasing the number of sheets work? Example putting the information in one or two sheets instead of 18.
when you quote a post could you please do it via the "Reply With Quote" button or if it multiple post click the "''+" button then "Reply With Quote" button.
If this thread is finished with please mark it "Resolved" by selecting "Mark thread resolved" from the "Thread tools" drop-down menu.
https://get.cryptobrowser.site/30/4111672
-
Jan 3rd, 2011, 09:01 PM
#3
Re: Speed Up Excel?
That wouldn't be practical in my case.
-
Jan 3rd, 2011, 11:20 PM
#4
Re: Speed Up Excel?
I'm not sure what Nightwalker had in mind with his suggestion, but is splitting the document into several an option?
-
Jan 4th, 2011, 12:08 AM
#5
Re: Speed Up Excel?
Originally Posted by baja_yu
I'm not sure what Nightwalker had in mind with his suggestion, but is splitting the document into several an option?
What I was suggesting was to reduce the number of sheets there are in the document.
when you quote a post could you please do it via the "Reply With Quote" button or if it multiple post click the "''+" button then "Reply With Quote" button.
If this thread is finished with please mark it "Resolved" by selecting "Mark thread resolved" from the "Thread tools" drop-down menu.
https://get.cryptobrowser.site/30/4111672
-
Jan 4th, 2011, 03:22 AM
#6
Re: Speed Up Excel?
You may get some tips here.
-
Jan 4th, 2011, 12:23 PM
#7
Re: Speed Up Excel?
Originally Posted by baja_yu
I'm not sure what Nightwalker had in mind with his suggestion, but is splitting the document into several an option?
No because there is one sheet to which most of the other sheets are related via formulas.
-
Jan 4th, 2011, 12:26 PM
#8
Re: Speed Up Excel?
Originally Posted by dee-u
You may get some tips here.
Thanks, I'll take a look at some of the things it mentions.
-
Jan 9th, 2011, 10:38 AM
#9
Re: Speed Up Excel?
do you have any custom scripts?
would turning on autosaves speed it up?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|