Share via

Missing formulas in Excel 2007

Anonymous
2018-03-18T22:11:01+00:00

I have a workbook with 26 sheets, more or less, with some hundreds of formulas.

The value on each cell, in the first sheet, is replicated in next sheets, same line, if some condition arises, and determined by a formula like (if something true, write ADQ false write NAD.

After closing the workbook/file, in next opening, I verify that some formulas are missing, and I only see one of the expected results.

Another ones simply are vanished and the line appears empty.

Is this a bug in excel, or am I doing things wrong? Some help is needed. If you want, I can send a copy of my file, with formulas, there is no question of privacy.

thanks

luis Fernandes

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

19 answers

Sort by: Most helpful
  1. Anonymous
    2018-03-19T08:08:55+00:00

    Hi Luis,

    I have received the link.

    I am right now in my office and unfortunately, our office security system does not allow us to

    go out of our Office Network (not even to OneDrive).

    I will have a look at your file in the evening once I reach home.

    You will have to wait for few hours. Hope it is fine with you.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2018-03-19T08:01:54+00:00

    Hi Rajesh

    It is very complicated to come here again. I never know what to do. I am always redirected to somewhere in microsoft. Nevertheless, I think that I could upload one of versions of my program in excel. The link sourced me is :

    https://1drv.ms/f/s!AuNkAfbP03UVZ6253vAKpKlVnCw

     I do not know if you can understand the meaning of the program:

    The first sheet has Items, each in each line. Each line has a name. The second sheet, analizes the column and decides if the Item of each line in first sheet should be replicated, or left the line empty.

    There are also formulas in top of each block, (different colors), that should print NAD ADQ, if the complete block is filled, with some caracter. I use X normally.

    Thanks for now

    luis

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2018-03-19T07:41:04+00:00

    Hi Rajesh

    How can I replay with the program where I find formula problems? How to append something?

    I am not an user of OneDrive. I will try to understand how to go there and save data.

    thanks

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2018-03-19T02:47:18+00:00

    I doubt that Excel would have any such bug!  Never heard of such a bug anywhere.

    Can you share your .xlsx file on OneDrive (and share the file link here pls)?

    So that we can have a look at the file and see if we can find something and help you resolve your problem.

    Was this answer helpful?

    0 comments No comments