Formula origin in Excel 2007
Thread poster: Samuel Murray

Samuel Murray  Identity Verified
Netherlands
Local time: 07:32
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


Direct link Reply with quote
 

David Turnbull
United Kingdom
Local time: 06:32
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


Direct link Reply with quote
 
Krzysztof Kajetanowicz  Identity Verified
Poland
Local time: 07:32
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.


Direct link Reply with quote
 


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






memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »



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