View original (French)

Excel, formulas that disappear

Laey -  
 Pierre -
Hello,

I have a problem at work with an Excel file. This file is shared between several stores, and we send it by email.
But when it is sent back to me, most of the formulas disappear and are replaced by a #N/A. This is quite problematic, and I really can't find the solution.
Not all workstations have the same version of Excel, but so far it hasn't been an issue.
Do you know what might be causing this?

Thank you in advance for your help!

Configuration: Windows XP / Internet Explorer 7.0

2 answers

  1.
    Bidouilleu_R Posted messages 1209 Status Member 296
     
    a beginning of an answer... I would say.
    if you see:
    1. #N/A this could mean that the formula still exists but the function returns because one piece of data is missing.
    2. or that someone did a copy/paste of values and only #N/A remains.

    with the little information available, it's hard to say more.
    To the question "Do you know where this might come from?"

    I would say that the problem lies between the keyboard and the chair....
    0
  2. Laey
     
    I love being messed with... thanks anyway, I'm going to find an answer elsewhere...
    0
    1. Anonymous user
       
      Good evening Laey

      Wow! There's no mockery here, Bidouilleu's conclusion is insightful, and a little humor doesn't hurt, does it? :-)) Because there is indeed one or more user(s) from one of your stores who are overwriting or modifying data in your file, probably unintentionally or out of lack of knowledge of the file.
      Maybe you should protect the file from data that should not be altered.
      But to tell you how, where and which ones, you should provide more information and also a small part of the file, so that someone can guide you. Please attach it with https://www.cjoint.com/ and paste the link here.
      OK?
      0
    2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Good evening,

      To clarify argixu's response (hi by the way :-) )
      You select the cells where you allow input, right-click on them / format cells / protection, and uncheck 'locked'.
      Then you protect your sheet, in 2003: menu 'tools / protection / protect sheet...' (with or without password).
      This will prevent all mishandling, the only cells that can be modified will be those that are unlocked.

      eric
      0
    3. Pierre
       
      For the moment, I believe the problem goes beyond the user... Excel is unstable; I myself created a tracking spreadsheet with quite simple but numerous formulas, and as we sent it via email, some of them disappeared partially, even though the spreadsheet was protected where the formulas are located...
      I did a live test with my colleague; a real headache. The only solution for us is to create a server accessible to everyone to place the spreadsheet in open access.
      0