Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Basically i have a huge spreadsheet, its almost 6000KB and my rubbish
com,puter cannot cope with it. I have an intel pentium 4 with 3.06GHz, 1.9GB hard drive according to the system properties. My spreadsheet has the following formula repeated on numerous lines: =IF(ISERROR(VLOOKUP($A15,ITLD004!$A:$E,4,FALSE)),0 ,VLOOKUP($A15,ITLD004!$A:$E,4,FALSE)) IT are saying its not my computer, i have over complicated the spreadsheet. Bearing in mind their first exuse for it crashing was that the columns were not all alligned correctly and this was causing it to crash :| i do not believe what they are saying. Surely there are larger companies using excel to a larger scale. However i am not 100~% sure on the computer side of things so if anyone out there can help it really would be much appreciated. Can a spreadsheet this size be too complicated to run? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a VERY complicated spreadsheet? | Excel Worksheet Functions | |||
spreadsheet macros run fine at home, but not on other computer | New Users to Excel | |||
Complicated spreadsheet | New Users to Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel |