Formula origin in Excel 2007
Thread poster: Samuel Murray

Samuel Murray  Identity Verified
Netherlands
Local time: 13:48
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: 12:48
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: 13:48
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






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »



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