+ Reply to Thread
Results 1 to 6 of 6

How to save all opened sheets at once?

  1. #1
    Registered User
    Join Date
    07-26-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    41

    How to save all opened sheets at once?

    I have many workbook around 10 to 20 opened on my desktop.

    I wish to click one time save and then it saves all the workbooks that are opened, instead of going to each workbook and click save which requires me to waste a lot of time.

    How can I click once save to save all the opened workbook?

    Thanks
    Last edited by rowrow; 11-26-2013 at 03:41 AM. Reason: edited typo sheets to workbook

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,698

    Re: How to save all opened sheets at once?

    Whether by mistake you are calling the workbooks as sheets?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,624

    Re: How to save all opened sheets at once?

    The following links may be useful......

    http://www.excelbanter.com/showthread.php?t=72022

    http://www.accountingweb.com/topic/t...le-excel-files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Registered User
    Join Date
    07-26-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: How to save all opened sheets at once?

    Quote Originally Posted by :) Sixthsense :) View Post
    Whether by mistake you are calling the workbooks as sheets?
    Yes My mistake. I mean workbooks (each excel file). I have corrected my typo.

  5. #5
    Registered User
    Join Date
    07-26-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: How to save all opened sheets at once?

    Quote Originally Posted by sktneer View Post
    These suggestions do not work. I do not want to close the files. I want to save and leave the files open. For example when I am leaving my desk for a break/lunch I will save all excel files.

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,698

    Re: How to save all opened sheets at once?

    I believe you have to go for VBA solution...

    Refer this link to know how...

    http://support.microsoft.com/default...&Product=xlw2K

+ 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. VBA: Save workbook in same folder where it is opened.
    By sroysroy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2013, 11:51 PM
  2. [SOLVED] Close ALL Already Opened Files without SAVE
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2012, 03:16 AM
  3. Save As - Can it be disabled for files opened as read-only?
    By BigO in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2010, 11:07 AM
  4. [SOLVED] always prompted to save opened workbooks
    By kjbrr in forum Excel General
    Replies: 4
    Last Post: 07-31-2006, 03:13 PM
  5. [SOLVED] save to same file as opened
    By dmtech in forum Excel General
    Replies: 6
    Last Post: 03-08-2006, 02:30 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