V
voodooJoe
stephanie -
6MB is probably not the problem as i've used bookmuch larger w/o incident.
could be the new pages are causing something in your macros to go awry.
in generaL, XL doesn't seem to like many many changes to the same workbook-
i guess things get gunked up behind the scenes.
you could open, update, saveas "week 1.xls" - then open "week1.xls" update,
saveas "week2.xls", etrc etc rather than copy all sheets to a new file
everytime. this is what I do with a large model I run each week. (and this
way I have a working copy of the model so I can rerun for historical results
if needed)
or you could save a clean copy of the model as a template, open a new
template file, update and save. this might simplify things.
just an idea or 2 - voodooJoe
6MB is probably not the problem as i've used bookmuch larger w/o incident.
could be the new pages are causing something in your macros to go awry.
in generaL, XL doesn't seem to like many many changes to the same workbook-
i guess things get gunked up behind the scenes.
you could open, update, saveas "week 1.xls" - then open "week1.xls" update,
saveas "week2.xls", etrc etc rather than copy all sheets to a new file
everytime. this is what I do with a large model I run each week. (and this
way I have a working copy of the model so I can rerun for historical results
if needed)
or you could save a clean copy of the model as a template, open a new
template file, update and save. this might simplify things.
just an idea or 2 - voodooJoe