Hello you excel expert ,
I knew excel but just recently understood it's power, now I'm Planning to build a Gigantic File on excel, probably gonna be reach in pictures, links, macros, and includes 1000's of worksheets ,
Recently I've done my first macro's and I've notice that macro's enable file actually opens slower, than non-macro's enable file..
that just the first que to make me nervouse,
THIS PROJECT IS VERY IMPORTANT TO ME,
so, I need all your Tips to make this file - really fast - for opening, viewing, and navigating.
I'll do whatever require from me (including top computer, and etc) but I'll love to get those really insight Tips in the building of the file (like not using Today() function because the cumputer allways trys to redo it, I know that in word I could have resize all the photos - though I don't know how to do it in excel, and as much as you've got)
Thanks ahead .
netanel.
I knew excel but just recently understood it's power, now I'm Planning to build a Gigantic File on excel, probably gonna be reach in pictures, links, macros, and includes 1000's of worksheets ,
Recently I've done my first macro's and I've notice that macro's enable file actually opens slower, than non-macro's enable file..
that just the first que to make me nervouse,
THIS PROJECT IS VERY IMPORTANT TO ME,
so, I need all your Tips to make this file - really fast - for opening, viewing, and navigating.
I'll do whatever require from me (including top computer, and etc) but I'll love to get those really insight Tips in the building of the file (like not using Today() function because the cumputer allways trys to redo it, I know that in word I could have resize all the photos - though I don't know how to do it in excel, and as much as you've got)
Thanks ahead .
netanel.