• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Efficiency

U

Usman Ghayoor

New Member
Dear Hui/Chandoo

Hope you guys are fine and you 2 with all the other members are doing an excellent job of making people awesome in excel.

Just a quick Q for now. As chandoo is an IT guy, help me with the system configuration required to the run following stuff in parallel on my laptop

- Minimum two excel file with 25 Mb size each
- a power point file of size lets say 10 Mb linked to the both the excel files with think cell (* thinkcell is add-in for PowerPoint which links your graphs with the data in excel)

Please not that currently my laptop config is

HP Elitebook 8470p
- Intel Core i-5-3210M @ 2.5 ghz
- Ram 2 GB (usable 1.8)
- 32 bit operating system

Now my excel, and PPT at times take too long to update graphs, with or without think cell plus crashes a lot, which certainly mean loss of work, time and data.

Looking forward for a thorough reply.

Cheers,
 
Hi, Usman Ghayoor!

As a new user you might want to (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, here go my first thoughts:
Usman Ghayoor said:
and you 2 with all the other members are doing an excellent job of making people awesome in excel.
Click to expand...
Hui for sure, but the other guy... what does he do? Just curious...
Usman Ghayoor said:
HP Elitebook 8470p
- Intel Core i-5-3210M @ 2.5 ghz
- Ram 2 GB (usable 1.8)
- 32 bit operating system
Click to expand...
Give it away to your kid or nephew, but only if he doesn't want to run Need For Speed - The Run.
And get a Toshiba Tecra W50-ABT1500 Workstation for you with i7-4800MQ, 32 Gb DDR3L, Windows 8.1 Pro x64, an additional 512 Gb SSD, Quadro K2100M 2 Gb graphics,... and who knows if Excel would run fine with that... but at least you tried :)
http://www.toshiba.com/us/computers/laptops/tecra/W50/W50-ABT1500
Usman Ghayoor said:
Now my excel, and PPT at times take too long to update graphs, with or without think cell plus crashes a lot, which certainly mean loss of work, time and data.
Click to expand...
Stop loss of work & data saving files before doing crashing things (like running in parallel 2 25 Mb workbooks and a linked PP file), go on losing time if hardware's not enough for the job.

Regards!
 
Hi Usman ,

If you are technically oriented , go through this article , and decide :

http://www.pcworld.com/article/260794/how_to_add_ram_to_your_laptop.html

My personal opinion is that the only problem with your hardware configuration is the inadequate RAM.

Secondly , the issue of applications crashing is not necessarily related to an inadequate hardware configuration ; more important is whether the workbooks have been well designed.

Narayan
 
thanks Narayan , I ll go thru the article you mentioned but for now would it be good if a go with win 7 64bit and RAM 4GB ???

or what you say the minimum RAM should be, given the problem I am facing (Crashing happens quite rare, it is the time which PPT* takes to update a single graph linked to excel ) ??

*PPT contains 150+ slides of linked graphs)

BR,

UG

NARAYANK991 said:
Hi Usman ,

If you are technically oriented , go through this article , and decide :

http://www.pcworld.com/article/260794/how_to_add_ram_to_your_laptop.html

My personal opinion is that the only problem with your hardware configuration is the inadequate RAM.

Secondly , the issue of applications crashing is not necessarily related to an inadequate hardware configuration ; more important is whether the workbooks have been well designed.

Narayan
Click to expand...
 
Hi Usman ,

If you have read the article , it would tell you that the RAM extension possible totally depends on the slots available ; if you can find out this , then I would suggest that you go for something higher , since RAM prices are not so high ; if your laptop allows it go for 8.

4 GB would have been enough if you were using Windows XP , but Win 7 itself needs much more than Windows XP , and 8 GB would probably be the right amount.

The time taken to update a linked object also depends on how the coding has been done ; are you sure that this has been done efficiently ?

Narayan
 
Hi All,

Just add what Narayan Sir had suggested:

Addition of more RAM not only depends upon Slot available but also on BIOS version. So just check your BIOS version and if any update is available, do it before going for RAM upgradation.

Also Check in Excel option whether multi-threaded option is checked or not. This also impacts speed.

Regards,
 
NARAYANK991 said:
Hi Usman ,

If you have read the article , it would tell you that the RAM extension possible totally depends on the slots available ; if you can find out this , then I would suggest that you go for something higher , since RAM prices are not so high ; if your laptop allows it go for 8.

4 GB would have been enough if you were using Windows XP , but Win 7 itself needs much more than Windows XP , and 8 GB would probably be the right amount.

The time taken to update a linked object also depends on how the coding has been done ; are you sure that this has been done efficiently ?

Narayan
Click to expand...
Coding !! are you referring to VBA , than its not applicable....I am just coping the graph from excel and pasting as linked Object in Powerpoint,, that's what I Call linking

and @Somendra Misra can you please how to do that "multi threaded" option ?
 
Hi Usman ,

That is what I meant ; you need to decide whether that method is the only one ; in the interest of speed , pasting the chart as a static picture might be better.

Narayan
 
You must log in or register to reply here.
Back
Top