| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
An extraordinary large spreadsheet
I have a large spreadsheet that uses about 30 pivot tables stored in one tab.
Other tabs are linked to that data. Whenever I have to change anything in the spreadsheet: changing a formula or adding a row, it takes about 7 minutes to calculate. I switched it to Manual calculation and, after changing a few things I hit recalculate. The program crashed. I could not believe it since I have Pentium 4HT 3.6 GHz and 1 gig ram. Can someone advise on how to deal with the problem? -- Sergei D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Large spreadsheet - Charts don't refresh | Charts and Charting in Excel | |||
| Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
| Generating Simple Reports From A Master Spreadsheet | Excel Worksheet Functions | |||
| Spreadsheet Security | Excel Discussion (Misc queries) | |||
| Big problem with large spreadsheet. | Excel Discussion (Misc queries) | |||
Linear Mode
