I have a spreadsheet that I received that is using a formula with a "Stored Values" in the formula. I have never run across this use before and I'm not sure where the values are stored and what they are. The full formula in the cell is:

='Stored Values'!C4*37.5

Is there a way I can look at what the stored values are and what formula or calculation is being done to come to those values? C4 in this worksheet is just text so I'm not sure how to access the values.

  • 4
    The way it is typed, "Stored Values" is another worksheet (tab). Look for hidden worksheets (tabs) that are in your workbook. – Eric F Aug 7 '18 at 15:57
  • 1
    superuser.com/questions/545131/… may be helpful – davidmneedham Aug 7 '18 at 16:25
  • Stored Values this is a Sheet in your Excel file. – Lee Aug 8 '18 at 6:13

As mentioned in the comments, that "Stored Values" in the formula references a different worksheet. This may be in a hidden worksheet, so right click on the worksheet name at the bottom of the screen then click "Unhide". This will bring up a list of worksheets which are hidden. Select the "Stored Values" worksheet, and click Ok. You should then be able to see the "Stored Values" worksheet, and look at the data you are looking for.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.