Hello Dan,
Thank you for your useful answer, however i will try to give you more information about the scenario that 's happening.
1- the SSD has a current capacity 58gb remaining which means 50% free of its original capacity 128gb. this will not lead to improvement.
2- concerning the cpu usage please check the cpu when i open google chrome + word 2013 + windows explorer folder--> cpu usage = 48% (COMODO Internet Security 19%) memory=78% (mostly google chrome)
3- i closed all the applications the cpu drops to 2 or 3 % then i ran excel sheet (size 200mb), it took 2 min 20 second to open (it s ok maybe a large file).
than it starts calculating alone and it mentioned below at the right side of the excel tab --> calculating: (4 processors): 3%,4%... and it took around 10 min to be able to touch easily SP4 again. in the meantime cpu =100% memory = 90%.
and wherever i start working with this large amount of data in excel (e.g. running an if, else statement, filtering or any calculation) it will start calculating for more than 10 min cpu & memory goes high fan speed /sound is high too.
4- i have test the internal copy for a folder from desktop to desktop on my sp4 max copy speed was 135mb/s
5- at my work i have a desktop PC i3, 4gb ram, ssd faster than the one installed here (R/W speed around 500mb/s) i am not facing this problem when working with such large excel files.
unfortunately i was not able to send you picture of the cpu usage n memory....
because no attachment feature.....
@danj & @bearl any suggestions!??
your help and cooperation are highly appreciated.
with kind regards,
Elie