+ Reply to Thread
Results 1 to 2 of 2

Shortcut to go to source cell not working across different workbooks or worksheets

  1. #1
    Registered User
    Join Date
    08-02-2014
    Location
    Manchester, England
    MS-Off Ver
    Mac 2011
    Posts
    1

    Shortcut to go to source cell not working across different workbooks or worksheets

    Hi,

    Using Excel 2011 for the Mac and having trouble with the shortcut for going to the source cell from a cell with a formula linking to that cell. While the shortcut cmd + [ works within a worksheet, it won't work when the source cell is in another workbook or another worksheet. Instead the message "no cells were found" appears.

    Does anyone have a solution to make this shortcut work across workbooks and worksheets?

    Thanks,

    Brodinator

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Shortcut to go to source cell not working across different workbooks or worksheets

    I've never touched a Mac, but on Windows, the code to trace off-sheet precedents and dependents is very obscure.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Eliminate need for duplicating source worksheets for hundreds of workbooks
    By snapfade in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2013, 06:41 PM
  2. [SOLVED] Double Click Cell to go to Source not working
    By john60 in forum Excel General
    Replies: 5
    Last Post: 11-29-2012, 07:00 AM
  3. selecting source workbooks according to names specified in cell - new columns
    By macroman123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2012, 12:20 AM
  4. selecting source workbooks according to names specified in cell - new columns
    By macroman123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2012, 10:51 PM
  5. [SOLVED] Display 2 formulas from source workbooks to destination workbooks
    By Excel_seek_help in forum Excel General
    Replies: 4
    Last Post: 04-27-2006, 03:20 PM

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