Adobe pdf converter for mac. I have a 35MB Excel spreadsheet with approx 10 worksheets. It looks like one sheet in particular is taking a long time to load and save. The worksheet is approx 80k rows and is full of formulas. I have changed the Calculation options from Automatic to Manual with no success. The department who is relying on this worksheet has several other Excel spreadsheets of smaller size (in MB and formulas) that are also taking long to open and save (approx 15 - 20 min). Convert mac to pc. Hardware and network are not an issue. This occurs on Win XP SP3 or Win 7 machines. Single core or multi core. 2GB or 8GB of RAM. On a network share or local desktop, the result is pretty much the same. My sheet 1 is 24 pages long but the scroll bar is as long as if the sheet were blank and, as you can imagine, when using the scroll bar you're instantly at the end of the 24 sheets. Any thoughs on what to look for to remedy the situation? According to the department head these docs are going to grow in complexity and size. Thanks, - Gymmbo. I assume we can also exclude any recent update(s) of various driver(s) like printer et al. Does the workbook contain any ActiveX controls? If so then You may consider to replace them with the Form's controls. Is this a file that has been around for a while, adding data, removing data? The truth is that Excel files can get corrupted in one or another way. A slow open/saving can indicate an issue with the file, especially now that external aspects have been investigated. Create a new workbook file and move the sheets to the new file. Kind regards, Dennis (http://xldennis.wordpress.com/). No recent updates that I am aware of. No ActiveX controls that I am aware of. It looks like upon further review I have 12 columns and 80K rows of formulas. Just copying this group of cells to a new worksheet takes approx 15 min and the majority of the cells are not even populated w/ data as this is a forecasting spreadsheet. I have included a couple of the formulas, not sure if any of this will help. I am wondering if there is a way to streamline the input. =SUMIF('[New Inventory Forecast 01.23.12.xlsx]Demand'!$A:$A,$B29,'[New Inventory Forecast 01.23.12.xlsx]Demand'!#REF!) =IFERROR(VLOOKUP($B29,'[New Inventory Forecast 01.23.12.xlsx]POs & TBR'!$A:$X,MATCH('[New Inventory Forecast 01.23.12.xlsx]Model'!D$4,'[New Inventory Forecast 01.23.12.xlsx]POs & TBR'!$A$4:$X$4,0),FALSE),0) I can provide a copy of the workbook or worksheet for review. Hi, Before my few days i solve from my network. Please completely read before do something. Actualy user apply some formating, instructions, color, font, fontstyle and color for whole row or column by pressing Alt+Space or Ctrl+Space. In this case or similer case your excel sheet look like you want but actualy they consume all over sheets 1000+ rows 1000+column. For remove: focus your working area. Then after last row of your working area press Ctrl+Space to select these row and press 'Shift+Ctrl+Down' Keys now you have select all rows from your end of working area to Down and delet it and save it. And do it for column also, of all sheets then save it. Once you finish this please re open and check its magicaly responce. Note: please backup your file for your safety is your file need this operation not: please see below image www.shariqdon.com. Hi, Before my few days i solve from my network. Please completely read before do something. Actualy user apply some formating, instructions, color, font, fontstyle and color for whole row or column by pressing Alt+Space or Ctrl+Space. In this case or similer case your excel sheet look like you want but actualy they consume all over sheets 1000+ rows 1000+column. For remove: focus your working area. Then after last row of your working area press Ctrl+Space to select these row and press 'Shift+Ctrl+Down' Keys now you have select all rows from your end of working area to Down and delet it and save it. And do it for column also, of all sheets then save it. Once you finish this please re open and check its magicaly responce. Note: please backup your file for your safety is your file need this operation not: please see below image www.shariqdon.com also you can make sense to see scrolbar size. Means its size and scroll belong to your sheet. Please see above image. I also come across situation like reasonable data but very big file size. There are several area you can check: 1. Is there any cells with no data but excel consider they are effective range? Suggestion: please press 'Find and Select' button --> Go To Special --> Last cell; that is excel effective range, you cannot delete un-used row or un-used column if the 'Last cell' was already marked by excel, but you can copy your data range to new workbook. Is there any hidden drawing/icon/picture within your worksheet? Suggestion: please press 'Find and Select' button --> Go To Special --> Objects; all objects will be displayed and you can delete unnecessary/duplicated objects.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |