A
Accesshelp
Good morning all,
I have an Excel file with two worksheets: Report and Data.
The worksheet Data has data where the data are stored, and the worksheet
Report is retrieving the data from Data to prepare a report by entering an ID
number. The data are retrieved using the vlookup formula in the Report
worksheet. The worksheet Data has 130 columns and 14,000 rows (up to) of
data.
The way it works is I enter an ID number in the worksheet Report. Then I
press F9 to do the calculation and the worksheet Report will start to
populate the data. Due to the size of Data worksheet, it takes about 2
minutes to have the Report worksheet fully populated.
The problem that I am having is the file freezes after I press F9. On the
bottom left corner, it shows Calculating Cells: 0% of Data worksheet, and it
would not move forward. I also tried to reduce the number of rows (from
14,000 to 300) to test whether it would help, and it did not help.
I have been using the file for months, and I have never had that problem
until recently. Recently, I made additions and deletions of columns in Data
and rows in Report, but the number of rows and columns stay the same from
before.
Does anyone have any idea of what causes, and how to resolve it?
Thanks.
I have an Excel file with two worksheets: Report and Data.
The worksheet Data has data where the data are stored, and the worksheet
Report is retrieving the data from Data to prepare a report by entering an ID
number. The data are retrieved using the vlookup formula in the Report
worksheet. The worksheet Data has 130 columns and 14,000 rows (up to) of
data.
The way it works is I enter an ID number in the worksheet Report. Then I
press F9 to do the calculation and the worksheet Report will start to
populate the data. Due to the size of Data worksheet, it takes about 2
minutes to have the Report worksheet fully populated.
The problem that I am having is the file freezes after I press F9. On the
bottom left corner, it shows Calculating Cells: 0% of Data worksheet, and it
would not move forward. I also tried to reduce the number of rows (from
14,000 to 300) to test whether it would help, and it did not help.
I have been using the file for months, and I have never had that problem
until recently. Recently, I made additions and deletions of columns in Data
and rows in Report, but the number of rows and columns stay the same from
before.
Does anyone have any idea of what causes, and how to resolve it?
Thanks.