Excel freeze up when copying a cell
Problem
My co-worker in Accounting department encounter a problem in Excel 2007.
Whenever she copy data from one cell to another, her workbook freeze up.
I close the excel file that hangs up and open it again. I notice that there is dialog
box that appears after the excel file is being opened. Here is the dialog box that
appear.
There is Circular Reference problem on excel file. We need to know
what the cause to remove Circular Reference problem.
Solution
1.We check the main problem of Circular Reference on the Excel file. The Circular
Reference dialog box will help you to pinpoint the problem in Excel file.
2. We remove the formula from a cell that cause Circular Reference.
3. After we solve the Circular Reference problem, we can now copy data from
cell and it does not freeze up again.
My co-worker in Accounting department encounter a problem in Excel 2007.
Whenever she copy data from one cell to another, her workbook freeze up.
I close the excel file that hangs up and open it again. I notice that there is dialog
box that appears after the excel file is being opened. Here is the dialog box that
appear.
There is Circular Reference problem on excel file. We need to know
what the cause to remove Circular Reference problem.
Solution
1.We check the main problem of Circular Reference on the Excel file. The Circular
Reference dialog box will help you to pinpoint the problem in Excel file.
2. We remove the formula from a cell that cause Circular Reference.
3. After we solve the Circular Reference problem, we can now copy data from
cell and it does not freeze up again.
