Formula origin in Excel 2007
Thread poster: Samuel Murray

Samuel Murray  Identity Verified
Netherlands
Local time: 08:33
Member (2006)
English to Afrikaans
+ ...
Sep 29, 2010

G'day everyone

I have an Excel 2007 file in which the visible text of a cell is XYZ WIDGETS but the cell's content is =UPPER(CompanyName). I figure that "CompanyName" must be defined somewhere in the file. The question is... where? How can I find out where that variable (for lack of a better word) is defined?

Thanks
Samuel


 

David Turnbull
United Kingdom
Local time: 07:33
Italian to English
In Excel Sep 29, 2010

Hi Samuel,

Usually when you select a cell with a formula in it the relevant cells are highlighted by different colour borders, so you can look through the sheets (unless it's absolutely huge) and find it.

It looks to me like it's been set up as a list, which would normally be found on one of the last sheets in the workbook.

If you want to send it to me I'd be happy to take a look.

David
david@legally-speaking-translations.com


 

Krzysztof Kajetanowicz (X)  Identity Verified
Poland
Local time: 08:33
English to Polish
+ ...
answer Sep 29, 2010

Samuel Murray wrote:

G'day everyone

I have an Excel 2007 file in which the visible text of a cell is XYZ WIDGETS but the cell's content is =UPPER(CompanyName). I figure that "CompanyName" must be defined somewhere in the file. The question is... where? How can I find out where that variable (for lack of a better word) is defined?

Thanks
Samuel


The answer lies in the Name Manager. Hope this helps.


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Formula origin in Excel 2007

Advanced search






WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »
BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search