Results 1 to 5 of 5

Is there a direct search for cells with formulas?

Threaded View

  1. #1
    Registered User
    Join Date
    08-10-2011
    Location
    BC Canada
    MS-Off Ver
    Excel 2007, 2010
    Posts
    8

    Is there a direct search for cells with formulas?

    Hi there,

    I just upgraded to Excel 2010 and now when I try to save some of my older files, I get this warning message saying that there is a risk of a "minor loss of fidelity" as there are formulas linked to other closed Excel files in the 2003 format. But this is showing up in a couple of files that I didn't even think had any formulas in it at all. I've already tried a manual look using the CTRL + ` step to change the view of the sheet to show formulas, and didn't find anything. Is there some kind of search function buried in the (not particularly better) menus that would allow me to find every cell in an Excel file that has a formula in it?

    Please advise,

    Daryl
    Last edited by Kiljaeden; 05-25-2012 at 01:38 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1