Formula origin in Excel 2007
Thread poster: Samuel Murray

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






SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

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