+ Reply to Thread
Results 1 to 4 of 4

Backup spreadsheet in several locations!?

  1. #1
    Forum Contributor
    Join Date
    10-11-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    358

    Backup spreadsheet in several locations!?

    I have a spreadsheet on a server, password protected, and certain columns, rows locked...

    This is shared with 6 others and can only be accessed one at a time.

    If It so that when the user saves the spreadsheet it saves over itself on the server it's located AND on the individual users computer as backup; how would I go about doing this!?

    Seriously need help as I am worried incase of corruption...

  2. #2
    Forum Contributor
    Join Date
    10-11-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    358

    Re: Backup spreadsheet in several locations!?

    Anyone have any ideas?

    Thought this was relatively straight forward?
    Last edited by domgilberto; 05-13-2014 at 03:25 PM.

  3. #3
    Forum Contributor
    Join Date
    10-11-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    358

    Re: Backup spreadsheet in several locations!?

    Does anyone have any ideas? The server is based in Brussels, but it looks like a C: drive in my computer... All I am wanting is when that user hits save, it saves it where the file is situated (on the server) and a copy of all the details on the desktop....?

  4. #4
    Forum Contributor
    Join Date
    10-11-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    358

    Re: Backup spreadsheet in several locations!?

    Please Login or Register  to view this content.
    This does it!

    Just change the " " to your drive. Then go Developer > Insert and select the little grey box to create a "Save here" button!
    Last edited by domgilberto; 05-13-2014 at 05:21 PM.

+ 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: 2
    Last Post: 07-09-2012, 12:28 PM
  2. Replies: 1
    Last Post: 07-11-2008, 06:38 AM
  3. Macro to Active and backup spreadsheet
    By rarin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2007, 10:11 AM
  4. Backup Spreadsheet while open
    By Sean in forum Excel General
    Replies: 2
    Last Post: 08-05-2005, 02:05 AM
  5. [SOLVED] stopping backup of Excel spreadsheet
    By lggallo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2005, 03:06 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