| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007
a file created in excel 2000 then converted to excel 2007 has one sheet that
responds very slowly and is driving me crazy. It does have a lot of formulae but the same sheet works fine in both 2000 and 2003. Please help -- izzy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2007
Check for lazy fill or border formatting. Often users will fill whole rows
and columns rather than the active area of the w/s. A w/s that performs adequately which was created in an older Excel version would have a potential 17 million cells approx but if that file were then converted to 2007 there is a potential 17 billion cells per w/s. If there is extensive fill that could explain the lack of performance. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Izzy" wrote: a file created in excel 2000 then converted to excel 2007 has one sheet that responds very slowly and is driving me crazy. It does have a lot of formulae but the same sheet works fine in both 2000 and 2003. Please help -- izzy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Excel 2007 chart to Word 2007 - only half of it shows | Excel Discussion (Misc queries) | |||
| Excel 2007 files not showing on screen when opened in Excel 2007 | Setting up and Configuration of Excel | |||
| Conflict in excel 2007 with Outlook 2007 attachment excel | Excel Discussion (Misc queries) | |||
| Labels: Unable to import all records Excel 2007 to Word 2007 Mailm | Excel Discussion (Misc queries) | |||
| Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Linear Mode
