Shared workbook opening and saving very slow

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a shared workbook with Macros that is opening and saving very slow. I
did copy all the sheets into an empty workbook to see if there was any extra
code tied to the sheets, 2 sheets had a problem. After I deleted the sheets
the workbook open and saved fin. After about 10 minuets it started to slow
down again, I rechecked all the sheets and they don't seem to have a problem.

Any suggestion on what is causing the problem.

Thanks
 
I went into tools and changed the calculation to manuel with out
re-calcualtion before save and it's still very slow
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for all Excel Workbooks to print to PDF 2
Copying cells and formula from closed workbook to all sheets in open workbook 0
save worksheet data to alternate closed workbook - next row 1
Error Message - Macro to Unlink MS Queries from Workbook 0
Export Sheet Values to new workbook 20
adding footer to all existing sheets in workbook and also to newsheets which is added 1
MACRO TO COUNT ALL OPEN WORKBOOKS and print 1
Save each sheet of multi-sheet workbook as a single-sheet workbook 3

Back
Top