Hello All
I have a pretty massive spreadsheet. it currently has 1,020,932 lines of data and I have 4 different formulas in 4 different columns. I am trying to copy the formulas down the entire spreadsheet by clicking on the little "tail" in the cell but for some reason it will not copy the formulas . Is the spreadsheet too big ?
This functionality works for me on other spreadsheets I have open but not on the this for some reason. Any ideas would be appreciated
Is there data in the column adjacent left of your formula? Are there blanks in the data adjacent left?
Dave
Sorry for the late reply. I have no blanks in the adjacent left column. I am wondering if it might be a matter of not enough RAM ?
Thanks so much
That was my next thought. Although I would expect Excel to pop-up an "out of resources" message box.
You never mentioned particulars of the formulas. Although that many rows is enormous I am sometimes surprised how formula structure and function selection can affect performance.
Another thought would be to check the status bar at the bottom of the screen. Does it show CALC?. ie your sheet may be working but the enormity of the data and calculations may just be taking time.
Beyond speculating as I have done the best I can suggest is uploading a severely trimmed down version of that workbook including those exact formulas (please don't upload the whole workbook). Instructions for uploading are in the 'gold' banner at the top of the page. Please note CONFIDENTIALITY details.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks