R
rbecker
I have a couple of workbooks (Excel '07) that I'm having trouble with them
being slow to open. One, I sort of understand why it's slow as it has a lot
of calculations, the other I'm not sure why. Here's the senarios an maybe
someone could suggest a way to get them to open quicker......
1. The most recent problem is with a worksheet where I'm taking a list of
our customers and the reoccuring work we do for them (and other important
info) and trying to make rolodex cards for each customer. I have the
complete list on sheet 1. Then on each subsequent sheet I have only one
customer's info per sheet in a format that will fit on the rolodex cards that
I want to use. I get the customer's info by connecting back to the sheet 1
(i.e. "=Sheet1!A1" in the cell) sometimes I have an IF statement if there is
a possiblity that the cell on Sheet 1 could be blank but other than that no
"calculations" per se. Is there any way to keep this one from being a pain
in the you know what everytime I open it or am I just SOL? I'm only on the
letter C.
2. The second worksheet is the one that is a doosey. I used to do this one
in Excel '03 before my computer crashed and I upgraded to '07. I never had
problems opening it until I got '07. I've tried saving it as every option
available but it doesn't help speed things up. I have to do a report for my
boss showing our billable time vs non-billable time and include what each
technician is paid vs what is worked (among other things). There are TONS of
calcs, not just on each worksheet for each week of the year (yes, I said
year) but back to the summary sheet which is what is printed out. Is there
any way I can have it do the calculations ONLY when the workbook is saved,
not when opened? I think that could possibly make it open a lot faster. I
try to not let the data entry part get so bad that I have to enter weeks at a
time so I could wait to save until then end. Then if it took a while to
save, I could just file the time folder away while it's saving.
Sorry this is so long but it's not easy to describe in a short way.
being slow to open. One, I sort of understand why it's slow as it has a lot
of calculations, the other I'm not sure why. Here's the senarios an maybe
someone could suggest a way to get them to open quicker......
1. The most recent problem is with a worksheet where I'm taking a list of
our customers and the reoccuring work we do for them (and other important
info) and trying to make rolodex cards for each customer. I have the
complete list on sheet 1. Then on each subsequent sheet I have only one
customer's info per sheet in a format that will fit on the rolodex cards that
I want to use. I get the customer's info by connecting back to the sheet 1
(i.e. "=Sheet1!A1" in the cell) sometimes I have an IF statement if there is
a possiblity that the cell on Sheet 1 could be blank but other than that no
"calculations" per se. Is there any way to keep this one from being a pain
in the you know what everytime I open it or am I just SOL? I'm only on the
letter C.
2. The second worksheet is the one that is a doosey. I used to do this one
in Excel '03 before my computer crashed and I upgraded to '07. I never had
problems opening it until I got '07. I've tried saving it as every option
available but it doesn't help speed things up. I have to do a report for my
boss showing our billable time vs non-billable time and include what each
technician is paid vs what is worked (among other things). There are TONS of
calcs, not just on each worksheet for each week of the year (yes, I said
year) but back to the summary sheet which is what is printed out. Is there
any way I can have it do the calculations ONLY when the workbook is saved,
not when opened? I think that could possibly make it open a lot faster. I
try to not let the data entry part get so bad that I have to enter weeks at a
time so I could wait to save until then end. Then if it took a while to
save, I could just file the time folder away while it's saving.
Sorry this is so long but it's not easy to describe in a short way.