However there are many speed-up tricks you can use to improve the performance of a slow Excel spreadsheet. Written by co-founder Kasper Langmann Microsoft Office Specialist. You can always view the full formula and even edit it from the formula bar.
Type an equal sign and then type a function.
As an example you can also list your formula errors. Once the Inquire tab is available in the ribbon click on Workbook Analysis and you will get an extensive analysis of the contents of your workbook. Open the excel sheet for which you want to find the external references. Click Find Select Click Go to Special Click Formulas Enable Errors Click ok.