Any thoughts on this query please
I am using the latest version of excel of have a report which contains 340,210 rows of data. Columns A to L are populated. With no formulas or formatting this is already a large document, however on a PC which has an 8 core processor I added a formula to M1. I tried to copy this down to row 15,000 and the workbook crashed. So I decided to switch the formula calculations to manual. I then tried to drop the formula to the end of the report.
The workbook has now not been responding for 3 hours
I appreciate the file is largish but ultimately it's one column with formulas on a spreadsheet which is only using a third of it's total rows....why should it find this so hard ?
I am using the latest version of excel of have a report which contains 340,210 rows of data. Columns A to L are populated. With no formulas or formatting this is already a large document, however on a PC which has an 8 core processor I added a formula to M1. I tried to copy this down to row 15,000 and the workbook crashed. So I decided to switch the formula calculations to manual. I then tried to drop the formula to the end of the report.
The workbook has now not been responding for 3 hours
I appreciate the file is largish but ultimately it's one column with formulas on a spreadsheet which is only using a third of it's total rows....why should it find this so hard ?
Last edited: