+ Reply to Thread
Results 1 to 2 of 2

Sharing Linked Spreadsheets

Hybrid View

  1. #1
    Registered User
    Join Date
    06-10-2011
    Location
    Michigan
    MS-Off Ver
    Excel 2003
    Posts
    1

    Sharing Linked Spreadsheets

    I have three workbooks that contain references to each other. I'd like to share these with my accounting folks, but cannot solve the problem of how Excel references the links when the spreadsheets are not open at the same time.

    Both PC's are Windows 7, so I am thinking there has to be a new solution for this old problem.

    I'd put the files on a shared server, and map both computers to a shared drive, except that our servers are in the cloud and running Linux -- so no safe/easy way to have them appear as a shared drive.

    I tried creating Libraries with the same name on both computers to no avail.

    Problem is unless my accounting folks remember to open all the workbooks together, I get a phone call that they have errors in them.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,227

    Re: Sharing Linked Spreadsheets

    Hi Moosemiester and welcome to the forum.

    I'm thinking you can create a Batch file with 3 shell commands to open all 3 workbooks. When they start their work they need to run the batch file and all 3 will be open and available. See: http://www.computing.net/answers/dos...en-/16149.html

    Another way might be to have an event macro in each of the workbooks that would open the other two workbooks. see http://www.ehow.com/how_6908038_open...using-vba.html

    hope this helps
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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