| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entry takes 1 min, Office 2007. Large sheet
Very large worksheet built in Excel 2003-7 now, in Excel 2007, there is a
long delay from entry to acceptance. I have saved versions in various compatibility forms. The sheet is loaded with 8 years of data and it would take an unreasonable amount of time to re-enter. Most of the data is text. Other fairly large spreadsheets have instant response. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Entry takes 1 min, Office 2007. Large sheet
That's awfully long.
I'd visit Charles Williams' site anyway: everything you always wanted to know about Excel performance and more. And I'd certainly try rebuilding the dependency tree with CTRL+ALT+SHIFT+F9 Save your workbook before trying -- Kind regards, Niek Otten Microsoft MVP - Excel "O'Bake" wrote in message ... | Very large worksheet built in Excel 2003-7 now, in Excel 2007, there is a | long delay from entry to acceptance. I have saved versions in various | compatibility forms. The sheet is loaded with 8 years of data and it would | take an unreasonable amount of time to re-enter. Most of the data is text. | Other fairly large spreadsheets have instant response. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Office 2007 compatibility pack on Office 2003 (slow network file | Setting up and Configuration of Excel | |||
| Office 2007 compatibility at office 2003 is not working for graphs | Excel Discussion (Misc queries) | |||
| It takes two full minutes to open existing files in Office 2003 | Excel Discussion (Misc queries) | |||
| Excel sheet send as emial body - office 2007 | Excel Discussion (Misc queries) | |||
| Excel (Office 2007 B2TR) -- Password Protecting A Sheet -- Character Limit ? | Excel Discussion (Misc queries) | |||
Linear Mode
