ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macros -enabled Workbook is getting slower and slower!! (https://www.excelbanter.com/excel-programming/409814-macros-enabled-workbook-getting-slower-slower.html)

Raja

macros -enabled Workbook is getting slower and slower!!
 
After rolling a spreadsheet every month by saving a copy of the old one and
deleting the old information the macro is getting slower and slower? What
could be causing this?

James Snell

macros -enabled Workbook is getting slower and slower!!
 
Couple of questions -

1) Are you using Save, SaveAs, or a file-copy to create the new workbook?
(save and "save as" are not the same in this context).
2) What is the size of the workbook compared to say 6 months ago?

"Raja" wrote:

After rolling a spreadsheet every month by saving a copy of the old one and
deleting the old information the macro is getting slower and slower? What
could be causing this?



All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com