crash xl

Hi Mr Excel, I have created a model and there is a row that is impossible to delete. When I try to delete it, the following error message comes up and I have to re-start Excel. 'Circular reference warning One or more formulas contain a circular reference & may not calculate correctly...

Hi, I have a macro that I have written (below) that extracts data from several different workbooks after entering some formula and collates them together into one workbook. The data sets are huge though, with some over 200,000 rows long. It causes it to run really slowly and eventually it...

folks, I do a lot of data crunching and make some big spreadsheets for a large company. with the amount of policy stuff running in the background plus my (most probably) personal code/formula style, I seem to always get issues with time. I either get to take a lunch break while files save or I...

Good morning, I have created a form with serveral userforms. Essentially it performs a costing calculation then gives the user the option to log the results in a table on the same page, looking for the next available empty row. Nothing in the code asks to save or close the workbook at any...

First time post.... Struggling with an Excel VBA problem as follows: Background: Windows Server 2003 used for a scientific application. No Internet access - just a closed private network Microsoft Office ExcelVersion 11. Build 6560 Application pathC:\Program Files\Microsoft Office\OFFICE11\...