[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Basic question about formulas

Posted on 2014-08-20
2
Medium Priority
?
97 Views
Last Modified: 2014-08-20
I have a spreadsheet with a cell whose calculation looks like this in the formula bar:

=+My_Calculations!AE4

Can someone explain this syntax to me, and where I can find the actual formula (I don't see any worksheets named 'My_Calculations').

Thanks -
0
Comment
Question by:mbizup
2 Comments
 
LVL 54

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 40272320
Hi,

it is a sheet

it may be hidden (right-click one of the sheet tabs and choose unhide to see it)

or it may be veryHidden then you can only unhide it if you have acces to the VBA Project

(Alt-F11 choose your file develop Microsoft Excel Ojects Click the sheet View Properties window and choose Visible xkSheetVisible

Regards
0
 
LVL 61

Author Closing Comment

by:mbizup
ID: 40272341
Thank you.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question