I am running Microsoft Excel 2010 under Microsoft Windows XP. I have one spreadsheet which is currently 56 columns wide and 1060 rows deep where I input daily production data. Most of the data in the Workbook is calculated using IF,THEN,ELSE statements to check for errors and keep the sheet clean of divison by zero errors.
I use VLOOKUP Functions to pull data from a dataset on another worksheet within the same book, and I have 1 macro which inserts a row, copies and pastes a row then deletes the original then copies a row containing the formulas being used to the now blank line.
There are a couple of sheets in the workbook that I use for quick calculations and such but nothing there which would eat up much overhead.
The problem I am having is the time it takes to do what I consider to be easy tasks, copy cells and insert rows. I also tried to move a block of cells I was working with on one of my extra worksheets in the book and it took over 3 minutes – to move 28 cells in an empty worksheet.
Nothing else that I use takes this much time. The file is saved as a Macro Enabled Excel workbook and I am using a copy that has been copied from our remote server to my desktop to allow it to run locally.
Where do I start to get this file to start working in a timely and efficient manner?