Calorie counting #N/A

**Sinom** · 03-18-2013, 07:21 AM

Greetings!

I have a slight problem with a calorie counting excel file.

This file was downloaded from the Office-site. I do not however fully understand the formulas so that I may edit them to my needs

For instance, the following image displays the tables that I want to fill, but only the first one (the default on in the file) is filled correctly. The others (that I added) does not seem to work.
03.18.2013-12.16.57.png

This was also a nice feature but I seems that it is trying to clear my formula row on the KCAL column. It changes the formula slightly when I press it.
03.18.2013-12.18.15.png

The file can be downloaded here - ExcelCalorieCounter2013.xlsm

Any help is appreciated

Regards - Sinom

**:) Sixthsense :)** · 03-18-2013, 07:38 AM

FoodLookup

Formula:

Please Login or Register  to view this content.

In F5 cell

Formula:

Please Login or Register  to view this content.

Drag it down...

**Sinom** · 03-18-2013, 08:19 AM

Thanks a lot for your response

That fixed the #N/A-problem quick and easy

Is there anyway that I can edit the "Save daily data and clear"-button?
Right now it seems to convert the following in the Kcal-column (but not the others):

Formula:

Please Login or Register  to view this content.

Into:

Formula:

Please Login or Register  to view this content.

I tried locking the table but it didn't help.

**EDIT**
I think I found a solution to this problem, as I stumbled upon the Macros in Excel I found the faulty formula line, I changed those lines to what they should be.
I didn't know how to stop the macro from changing them at all but as long as it changes it to change it should be, it works

Thanks for your help Sixthsense

Regards - Sinom