1. V

    Improve Calculation Speed

    Is it faster to have fewer dependencies and more columns or vice versa? Thanks
  2. A

    Is there a way to navigate through a formula's precedents, jumping from one to the next?

    It's very useful to be able to press CTRL+[ in order to navigate to the first precedent/reference in a formula. (And then to press F5 to jump back to the formula.) However, what if a formula has multiple precendents/references, including some or all that appear on a different worksheet? It...
  3. R

    Excel - Mapping External Links with Flowchart

    I'm working on updating a file from my work predecessor that has some external links. As I opened each external link, I find that each of those files have external links and this continues for about 5 levels deep. Is there a way or program that will map all the external links back to the...
  4. Q

    Cycling through precedents

    Hi all, At my previous employer we had a tool/shortcut that allowed us to click on a cell containing a formula and then cycle through its precedents using shortcuts. The cycle was started off with CTRL+G (repurposed from Microsoft's default use) and then you could move to each precedent of the...
  5. A

    Conditional formatting with odd behaviour

    I require conditional formatting to apply a cell color, either red or green depending on whether it is greater than a critical value contained in an adjacent cell or less than or equal to that same value. The cell to be formatted displays the result of a calculation whose precedents are...
  6. S

    Count cell references and ranges (as one) in a formula

    Hi everybody! First time poster, and VBA newbie here. I've been trawling the internet and racking my brains to try to solve my problem but haven't got anywhere, so thought I'd register on here to see if anyone can help... The issue I have is that I'm trying to analyse a formula and I want to...
  7. J

    BUG in Excel re formula precedents

    Hi, I thought I’d share this to get your thoughts. I have only 2010 – does anyone get the same with 2007, 2013, 2016, etc.? Steps to reproduce: 1. Create a new workbook with at least two tabs. 2. On one tab make a table (ListObject) with headers and data a. In cells A1:A2 enter a label...
  8. Z

    Locate the source cell of a LOOKUP function using VBA

    I want to locate the cell that a lookup function (VLOOKUP, HLOOKUP, or INDEX) gets its value from. For example: if Cell A2 = "lookup_ref" then VLOOKUP("lookup_ref",A1:D4,3,False) should return the value of cell C2. I need to be able to find out what the source cell (i.e. C2 in this...

Some videos you may like

This Week's Hot Topics