Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Similar to 'Reference Data' in the publicly accessible file described below.

There is the Capacity Planning Guide spreadsheet excel file on Capacity Planning Considerations for Windows Azure Caching, it is downloadable.

The fact of the matter is that it contains formulas like ='Reference Data'!F128

Reference Data in Excel formula

Trying to trace precedents of this formula leads me to an empty cell where I just get an The trace Precedents command requires that the active cell contain a formula which includes valid references. exclamation.

The trace Precedents command requires that the active cell contain a formula which includes valid references

Can anybody tell what do such formulas mean and how are they really calculated?

share|improve this question

migrated from stackoverflow.com Feb 1 '13 at 17:11

This question came from our site for professional and enthusiast programmers.

add comment

1 Answer 1

up vote 8 down vote accepted

It's hidden in VBA. Go to the Developer tab on top, and then click Visual Basic.

At the left, you'll see something like "VBA Project (Windows Azure Caching Capacity Planner)

Under that, you'll see "Sheet3 (Reference Data)"

If you look at the properties for this Sheet3, you'll see that "Visible" is set to "2 - xlSheetVeryHidden" which not only hides it, but removes it from the Unhide feature in Excel.

enter image description here

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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