+ Reply to Thread
Results 1 to 3 of 3

Cannot get formulas to pull info from other Workbooks

  1. #1
    Registered User
    Join Date
    09-27-2021
    Location
    Alabama
    MS-Off Ver
    10
    Posts
    2

    Cannot get formulas to pull info from other Workbooks

    I have three excel files that must "talk" to each other to function. They are very large with lots features. In order to work they must have formulas that reach into other. An example would be "=[OtherFile.xlsm]Sheet1!A1". This "OtherFile" is in the same folder as the current Spreadsheet.

    For the longest time, this was done by clicking on the cell in the OtherFile, but that isn't working anymore and I have no idea why. If a click on a cell in "ThisFile" and type in "=" and then click on a cell in "OtherFile", nothing happens. It only places a "=" in the cell in "ThisFile" when earlier it would place "=[OtherFile]Sheet!XX##". If anyone knows why it doesn't do that any more, it would be very greatly appreciated.

    Thank you.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,696

    Re: Cannot get formulas to pull info from other Workbooks

    It still does it for me using Office 365. Are you using just one instance of Excel? If you are running two instances I don't know if that will work. It is likely something you are doing different, rather than something in Excel.

    Can you be more specific about which version of Excel you are using? Your profile just says "10".

    Version 10.0 for Windows is Office XP. That is a 20-year-old version.

    Version 10.0 for the Mac is Office X. That is also 20 years old.

    Neither one is still supported, and very few people, if any, still have either one to be able to reproduce your problem.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    09-27-2021
    Location
    Alabama
    MS-Off Ver
    10
    Posts
    2

    Re: Cannot get formulas to pull info from other Workbooks

    Windows 10 Enterprise, running Microsoft Office 365 from 2016.

+ 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. Replies: 1
    Last Post: 02-10-2016, 11:26 AM
  2. [SOLVED] Formulas to pull info based on certain special character
    By BROOF in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2013, 09:04 AM
  3. [SOLVED] Macro to pull info. from two workbooks to autopopulate a "tag"
    By traceylreed in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-25-2012, 01:00 PM
  4. formulas pull the data:Links to other workbooks
    By catalyst in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-06-2005, 03:34 PM
  5. [SOLVED] How do I get MS Query to pull info from 3 different workbooks?
    By Husker87 in forum Excel General
    Replies: 0
    Last Post: 05-06-2005, 05:06 PM
  6. Compare two workbooks and pull in info from one into the other
    By Dbase Beginner in forum Excel General
    Replies: 2
    Last Post: 03-28-2005, 10:01 AM
  7. Pull info between workbooks
    By Solomon King in forum Excel General
    Replies: 3
    Last Post: 01-12-2005, 10:05 AM

Tags for this Thread

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