I have a spreadsheet that is used to hold a large amount of data keyed daily. The problem is I am trying to restrict duplicates (http://www.mrexcel.com/board2/viewtopic.php?p=1392318#1392318 so I am having to stick in conditional formatting. There are also formulas in that need to be copied down quite far ready for all the new data to be added.
At the moment, I have 65 columns of data and the formulas go down 10000 rows, giving me a possible 650,000 cells of data. At the moment there are 5 columns with formulas in (65,000 cells) and conditional formatting across all of them.
All this added together seems to be slowing the spreadsheet down, so I was just wondering if anyone knew of an easy way of making things more efficient?
The spreadsheet itself is only 8MB so I don't think the physical size is a problem as I have worked on much larger files in the past with no problems, so my assumptions lead to the number of formulas and the conditional formatting.
At the moment, I have 65 columns of data and the formulas go down 10000 rows, giving me a possible 650,000 cells of data. At the moment there are 5 columns with formulas in (65,000 cells) and conditional formatting across all of them.
All this added together seems to be slowing the spreadsheet down, so I was just wondering if anyone knew of an easy way of making things more efficient?
The spreadsheet itself is only 8MB so I don't think the physical size is a problem as I have worked on much larger files in the past with no problems, so my assumptions lead to the number of formulas and the conditional formatting.