Also works with Word, Outlook, Powerpoint, and all of Office 2007/2010/2013. Every time I'd open Excel 2013 under Windows 8, it would crash instantly, leaving me a message: 'Excel 2013 has stopped working'. I looked around and found a. This is a very vast field and here sky is the limit. All you need.

About Joe Macre: Joe is best known as bassist for the progressive rock band “Crack The Sky” best known for achieving debut album of the year in Rolling Stone Magazine. Joe was a member of Crack The Sky from 1975–1980. Joe has also worked with The B. Taylor Group, Wild Cherry, King Friday, and the KINGS’s. Joe is not just a world-class bassist, producer, and engineer, but the founder of Cuppa Joe Music, which produces various artists, and compose’s custom scores and sound design for film and TV. After relocating to New York, Joe became an engineer and studio musician and performed with artists such as Jim Croce, David Sanborn, The Brecker Brothers, Marie Osmond, Keith Green, Clint Brown and others. As Joe’s career expanded into television, he began scoring and engineering for national clients Pepsi, Burger King, McDonald’s, Ford, Nickelodeon, Showtime, Bud Light, Corona Extra, and Walker Texas Ranger.

Engineer/Sound Designer at Post Op-Editorial in Dallas Texas, Joe is one of the country’s most sought-after mixing engineers. Award-winning credits in films include Monster in Law, House of D and Fire Down Below.

His “Cuppa Joe Music” Library and Sound Design are chosen for many national spots, including the award-winning Super Bowl Tabasco’s “Mosquito”, Corona’s “Ship in a Bottle”, Nickelodeon, Showtime, Ford, McDonald’s, Corona, Hyundai, and Oprah Winfrey. Joe has served as an Instructor of Post Production Audio and Music Producing/Composing at Mediatech Institute in Dallas Texas. He also served in the capacity of Director of Career Services, placing students in full-time audio positions.

He exceeded government and state placement quotas of 70% in each graduating class. He was recently inducted into the board of directors for SPARS (Society of Professional Audio Recording Services) with Leslie Ann Jones, Audio Director at Skywalker Sound, Kevin Mills at Larrabee West Studios, Tim Butler at Chicago Recording (CRC), Jeff Greenberg at The Village Recorder and Steve Davis at Crawford Communications Atlanta. Joe is an active member of AES and the American Federation of Musicians.

2016 Joe starts work on his latest project Joe Mac’s American Garage with a debut album to be released in 2017 with a cast of up and coming musicians and superstars including Grammy Award Artist Madukwu Chinwah, Steve Major (King Friday), Victor Tasson (Unified Past), David Kowalski, John Palumbo (Crack The Sky), Phil Naro (DDrive), Vinni de Paul (Crack The Sky), Robert Schindler (Johnny Nash), Scott Osterloh, Pete Hewllett (Billy Joel), Cory Holland (KING’s), Andy Timmons (Danger Danger), Trai’D & Tom Braxton. According to Joe.

American Garage represents the ideology that bands and music are born in a garage. MRR Releases Joe Mac’s American Garage (TBA) 2017 Joe Mac’s American Garage – (Single) with the B – Side – 2017 Joe Mac’s American Garage – (Single) 2017 KING’s – KINGs (EP) 2014 King Friday – 2012 Other Releases.

For Microsoft ® Excel ® Excel formula auditing taken to the next level! Features: • Easy Auditing of formula dependents and precedents, including object dependencies (charts, pivot tables, form controls, Validation formulas, Conditional formatting formulas, etcetera) • Find circular references (yes, all of them!) • Trace errors • Time your workbook calculation for each worksheet to find bottlenecks • Check columns for formula inconsistancies A single user license for RefTreeAnalyser costs € 30 (excluding local VAT). A license includes: • Installation and use of the tool on two computers • One year of free updates. Prices Number of licenses Price per licence 1-10 € 30.00 11-50 € 23.00 if you'd like to order more than 50 licenses Free Use the links below to download the tool. The tool will work without a license code but with (only slightly) limited functionality. After purchasing a license, you can simply enter the license code into the tool's settings dialog. The limitations will be removed instantly.

Current Excel versions (Excel 2007 and up) V2.0 (Build 122, Updated Nov 23, 2017, downloaded: 10,790 times) Excel 2003 Please note that the 2003 version will no longer be updated! V2.0 (Build 082, Updated Dec 15, 2015, downloaded: 1,238 times) Blocked files problem Recently (I write this in August 2016), Microsoft has 'enhanced' security and is now blocking any files that are downloaded from the internet. This means that any add-in you try to open after downloading will simply not open in Excel (without display of a warning message!). To resolve this, follow these steps: 1. Copy the add-in from the zip file to any folder 2.

Right-click the xla(m) file and choose properties: 3. Click the Unblock button: Money back guarantee If you are in any way dissatisfied with RefTreeAnalyser, contact me within 30 days after your purchase and I'll issue a refund. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be!

Now there is the RefTreeAnalyser, the must-have expansion of your Formula tab of the Ribbon! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze. RefTreeAnalyser makes tracing precedents and dependents a lot easier than Excel's built-in tools.. Supported Excel versions RefTreeAnalyser is designed to work with Excel 2000 and up, including all 64 bit Excel versions. More information. Jan Karel, Today I had need for such a tool so I downloaded the demo.

I clicked on a cell and chose 'dependents'. It started going through every row of another sheet which has about 1,300 rows. It was taking quite a while, so I hit stop and after about a minute it did. I wonder if Application.ScreenUpdating would speed things up? I then ran the uninstall from Add/Remove progams.

It reported success, but the 2-icon toolbar was still in Excel. When I clicked on the left-hand button, I got the same message I'd get if I chose Tools>Formula Auditing>Trace Dependents. I deleted the toolbar in Tools>Customize and it's gone for good. I have 2 versions of XL on this computer 03 and 07. The toolbar is only present in 03 - I'm not sure if it was ever installed in 07. I thought you might like to know this.

Doug Comment by: Jan Karel Pieterse ( 10:24:07 PM). Hi, This is a really great tool.

I just started using the paid version, and it is incredibly helpful for me to debug spreadsheets. I believe that there is a defect whereby a sheet name containing a single quote (e.g., FTE's_Single Site) is not 'auditable' (i.e., when a cell from this sheet shows up in Dependants, clicking on it does not take me to the cell). When I remove the single quote from sheet name, all works fine. Please fix, if possible. Comment by: Jan Karel Pieterse (9/23/2008 1:25:00 AM). Hi, I want to know how to nest different conditions in single cell. Eg., Row A1=X, Row B1=Y, Row C1=Z the row D1 = Autopopulated.

If Rows A1, B1 and C1 are dropdown lists, how to nest and autopopulate in row D1 for possiblities in rows A1, B1 & C1. Currently, all conditions are in different rows with formula =IF(AND(A1='A',B1='R',C1='T'), 'Template Name','Error') I would like to know if your tool can help me out on this function. Regards, Chandru Comment by: Jan Karel Pieterse (5/4/2011 12:00:28 AM). Jan, This is a great tool! I'm currently using the demo version but am thinking of upgrading to the full version.

One question - when using the tool in tile mode, is it possible to return focus to the spreadsheet window using the keyboard and without closing the tool window? I have tried 'ALT + TAB' but I can't seem to go back to the spreadsheet window after activiating the tool. I ask as I use keyboard shortcuts alot and it would be good to keep the tool window up while auditing formula to avoid the windows resizing every time the tool is activate.

Thanks, Robert Comment by: Jan Karel Pieterse (2/10/2012 12:57:23 AM). As noted the issue is for Object key only. I found a sequence that is a workaround -assign a new letter to eg X or leave it blank -close excel and restart when assigning X, it is now the key that is locked to Objects and my existing Shift + Ctrl + H can be run However as with H, X is now stuck with or without the checkbox on the setting tab. Only way to release X is to have another letter assigned to it or leave it blank. Overall it seems that the checkbox is NOT deactivating the Hotkey for this case. I myself have found Application. Acme Anvil Serial Numbers. MacroOptions buggy at times so perhaps this is a clue if you are using this.

Comment by: Jan Karel Pieterse (4/10/2014 3:20:57 PM). Hi, Jan Karel, since one of the major updates (already few months ago), I am having quite some problems especially with some hot keys. I am using Version 2.0 Build 54 (Excel 2007 12.0.6683,5002 SP3 MSO).

- Help File in Excel for the tool does not work for me. I can call it up and see the index but cannot enter any of the actual entries. - Hot Keys: For me Shift+H seems to be a hot key selecting and checking some column (calls up a window 'Found formulas in a range' if I select a non-empty cell).

There seems to be no short key that can be disabled in the setting. And using Shift+H for a key would be rather unusual as I cannot type anything in Excel starting with a capital H unless I turn off the add-in. Happy if you can have a look (and imagine) what I may be missing. Thanks Comment by: Jan Karel Pieterse (5/8/2014 7:10:41 AM).

Jan-Karel, I still struggle with the shortcuts. It seems to block a number of common key / shortcuts or other ones that I have already defined which I find quite inconvenient and I cannot seem to disable it? 1) Whether I check or uncheck the Ctrl+# shortcut in the settings, either the #-key or the Ctrl+#-key (for standard date formatting) is blocked.

2) Whether I check or uncheck the Ctrl+O shortcut in the settings, I cannot use the cominbation of Ctrl+Shift+O which seems counterintuitive. I have a shortcut assigned to that combination. Can you take a look at this and advice a way around this?

On 2) I could assign a different shortcut of course (which I would avoid from pure habit). On 1) I see currently no workaround at all.

Regards Comment by: Jan Karel Pieterse (8/12/2014 10:53:30 AM). Hi, Thanks for the lovely formula auditing tool! I'm evaluating version 2.0 Build 055, unfortunately I run very often to a VBA error message when I try to trace precedents: Run-time error '- (80040001)': Duplicate key: 'Precendents'Sheet1'!1681b'[myWorkbook.xlsm]Sheet2'U314bRoot' I haven't discovered any clear pattern when this error message appears, but it always happens with same cells and about half of the formulas in my workbook.

I have Excel 2013. Do you know what could cause this? Comment by: Jan Karel Pieterse (8/15/2014 3:59:52 PM). A great, great formula diagnostic tool.

One issue, I am used to having RefTree menu choices come up in the Excel right click mouse menu (from older versions of RefTree). I have noticed that the current version sometimes has the Reftree menu choices in the Excel right click menu and sometimes not. This strange behavior happens on my Win764bit/Excel201332bit and my Win8.164bit/Excel201332bit computers. Could you add the ability to control the RefTree menu add to the Excel right click menu in the RefTree setting menu and force a reset of the Excel right click menu tree so that RefTree is included if so set?

Comment by: Jan Karel Pieterse (8/22/2014 8:41:09 AM). I see others have mentioned the issue with table lookup formulas (most commonly vlookup or hlookup).

Currently, a dependent is listed if it refers to a cell within the Table_Array parameter of a vlookup or hlookup formula. Anti Deep Freeze Windows 7 Free Download. The dependent is shown even if the Row_Index or Column_Index number points to some other cell within the Table_Array.

Presumably, it would be difficult to parse the formula to determine if the lookup would hit the active cell. As a work-around, I would be happy with an option to drop any dependents for which the cell formula is a table lookup.

Thanks Comment by: Jan Karel Pieterse ( 11:41:56 AM). Hi Phil, The thing is, RefTreeAnalyser parses the formulas to extract cell references. There is no intelligence there to do things which are specific to one type of function, such as lookup functions and OFFSET or INDIRECT. This is also the case for Excels built-in formula tracing tools.

If you need to know which part of a table is 'used' by a VLOOKUP, perhaps it is a better idea to use INDEX and MATCH instead. Combining these two functions enable you to point directly at the column from which the item is to be retrieved, rather than the convoluted column index number VLOOKUP requires you to use (and is much harder to audit in my opinion). Comment by: Phil Guerney ( 12:54:03 PM). Thanks Jan, I agree. Ever since learning about INDEX-MATCH, I have used it for my own spreadsheets.

Unfortunately, I have to audit other peoples' work and the use of the table lookup functions does make this difficult. The one I have in front of me today has formulas like this: =HLOOKUP(D$751,$D$2:$AH$745,455,FALSE) which refers to a block of data 31 cols x 744 rows and I have to scroll to find the 455th row (in this case) to see the precedent value because RefTreeAnalyser only refers to $D$2:$AH$745 as the precedent. If I select cell D456 and ask for dependents, I get a list of 28 cells or ranges which 'depend' on this cell, although only 7 really do so. Anyway, thanks for a great tool which does save me a huge amount of time for a lot of the tedious work involved in my work. Phil Comment by: Robert Ed (3/6/2015 12:03:45 PM). Hi, When I open your RefTreeAnalyserXL.xlam for first time, a message shows 'Excel found unreadable content in 'RefTreeAnalyserXL.xlam'.

Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.' I click Yes and another message popup says 'Cannot run the macro 'rxreftreecustomUI_onLoad'. The macro may not be available in this workbook or all macros may be disabled.' I have turn on macro.

So I think the file ZIP have some problems. Please fix it soon. Best Regards, Comment by: Jan Karel Pieterse (5/23/2016 10:22:04 AM). I just downloaded the demo version and it has been working great all day for tracing precedents across multiple sheets in a model. When I opened up the same workbook this evening it does not appear to be working.

I will select a cell and hit 'precedents'. First the pop-up screen shows up asking for license info. Then I hit 'close' and it runs through the tracing precendents process, but then either does not display anything, or displays the excel built in precedent tracing arrows. I am using excel 2010. Comment by: George (11/8/2016 6:52:51 AM). Hi Marvin, It seems some recent updates are preventing RTA from working. I am looking at how I can resolve these issues.

Have a question, comment or suggestion? Then please use this form. If your question is not directly related to this web page, but rather a more general 'How do I do this' Excel question, then I advise you to ask your question here:. Please enter your name (required): Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information): Your request or comment: To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB]. Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.