View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DP7 DP7 is offline
external usenet poster
 
Posts: 54
Default Spreadsheet performance

Hi, I have a monster spreadsheet that has 62 columns, 23 formulas 10 of which
are vlookups, there are 5 complex IF statement. As u can imagine the spread
sheet is very cumbersome to work with. I know the long term solution to this
problem is to move this "report" to a database. In the mean time does anyone
have any suggestion as to how to make this report more robust! ANY
suggestions are welcome.