View original (French)

Calcul on order in Excel

Arnaud -  
Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   -
Hello,

I have a quite heavy Excel file, and to prevent Excel from slowing down due to constant recalculations, I set tools/options/calculation to manual (with recalculation before saving).
The issue is that I have another file, which is shared within the company, and as soon as someone else opens this file over the network, their Excel settings automatically change to manual calculation. I know this, but it's very annoying for my colleagues who think Excel is not working on calculations! They thus need to remember to press F9 to recalculate Excel.

What can I do to eliminate this inconvenience?

Thank you in advance,

Arnaud
Configuration: Windows XP Internet Explorer 8.0

6 answers

  1.
    qmike Posted messages 1599 Registration date   Status Member Last intervention   594
     
    Hello
    yes you want the calculation to be done when ???????
    0
  2. Arnaud
     
    Good evening,

    I don't mind pressing F9 to perform the calculation at my request, but what I would like is for it not to disrupt the Excel configuration on other computers!

    Thanks in advance,

    Arnaud
    0
  3. qmike Posted messages 1599 Registration date   Status Member Last intervention   594
     
    Why do you want this to disrupt the configuration of other workstations???
    f9 = f9 on all workstations
    0
  4. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    The choice is yours:
    Either you explain to your colleagues that they need to use F9, or you remove your calculation blocking option every morning before going to work.
    --
    Retirement is great! Especially in the Caribbean... :-)
    ☻ Raymond ♂
    0
  6. Arnaud
     
    Hello,

    The issue I have is that on my workstation, I am set to "manual calculation" and I perform calculations on my workstation using the F9 key. Since some office colleagues are using another Excel file on the network that I also created, opening this file disrupts their "automatic calculation" setting to "manual calculation," which they do not want.
    Is there a way to prevent Excel from changing my colleagues' settings while the shared file is created in "manual calculation"?

    Thank you in advance,

    Arnaud
    0
  7. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    So it is the second term of my alternative that needs to be applied.
    Because to my knowledge what you want is not feasible (unless a specialist like m@rina had a miracle solution ...).
    --
    Retirement is nice! Especially in the Antilles ... :-)
    ☻ Raymond ♂
    0