Missing formulas in Excel 2007

Question

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

Answer 1

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.

Answer 2

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

Answer 3

Hi Luis,

The following links will help you understand the procedure to upload files on OneDrive

https://support.office.com/en-us/article/upload-photos-and-files-to-onedrive-b00ad3fe-6643-4b16-9212-de00ef02b586

https://support.office.com/en-us/article/share-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07

https://support.office.com/en-us/article/video-upload-files-and-folders-to-onedrive-7f630d4a-0af2-40f9-a32a-de5f149eb1de

Answer 4

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

Answer 5

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.