Results 1 to 3 of 3

Thread: Cause of Document Not Saved in Microsoft Office

  1. #1
    Join Date
    Jan 2005
    Posts
    43

    Cause of Document Not Saved in Microsoft Office

    Windows added some updates on my system. I am using Office 2007. It was working fine before. But as the new updates were installed I am not able to save my documents. I am getting a error on the same. When I try to save the file no a network drive the application freezes and then I am not able to save the files. It is a bit complicated to work on it. There was no issue with the same before.

  2. #2
    Join Date
    Nov 2005
    Posts
    36
    Try to remap the drive. It looks the location is changed or the network folder is not available due to which you cannot save it. You have to check properly that the space is available and your system permission to save the file. Just remap the drive and then check back. It is possible some recent changes in the system would have generated the problem.

  3. #3
    Join Date
    Feb 2011
    Posts
    1

    re: Cause of Document Not Saved in Microsoft Office

    Solution:

    I have an Excel file with 16 sheets having embedded objects. One of the sheets (16th sheet) is the summary of the other 15 sheets (embedded objects & data). I did some processing and tried to save as the file but it did not save the 14 sheet, error "document not saved,". I added below subroutine and called this during the other process and it resolved the problem.

    Sub ListAllObjectsActiveSheet()
    Dim NewSheet As Worksheet
    Dim MySheet As Worksheet
    Dim myshape As Shape
    Dim I As Long

    Set MySheet = ActiveSheet
    Set NewSheet = Worksheets.Add

    With NewSheet
    .Range("A1").Value = "Name"
    .Range("B1").Value = "Visible(-1) or Not Visible(0)"
    .Range("C1").Value = "Shape type"
    I = 2

    For Each myshape In MySheet.Shapes
    .Cells(I, 1).Value = myshape.Name
    .Cells(I, 2).Value = myshape.Visible
    .Cells(I, 3).Value = myshape.Type
    I = I + 1
    Next myshape

    .Range("A1:C1").Font.Bold = True
    .Columns.AutoFit
    .Range("A1:C" & Rows.Count).Sort Key1:=Range("C1"), _
    Order1:=xlAscending, Header:=xlYes
    End With

    End Sub

Similar Threads

  1. Office 2010,Excel document not getting saved
    By Parvati in forum Operating Systems
    Replies: 3
    Last Post: 27-10-2010, 12:52 AM
  2. Microsoft Office Document Scanning
    By Moiz in forum MS Office Support
    Replies: 3
    Last Post: 04-06-2010, 07:49 PM
  3. Does Office 2007 contain Microsoft Office Document Imaging?
    By m3pilot in forum MS Office Support
    Replies: 3
    Last Post: 30-12-2009, 08:54 AM
  4. Microsoft Office Document Imaging
    By NIcaBoy in forum Windows XP Support
    Replies: 5
    Last Post: 07-05-2009, 12:44 PM
  5. microsoft office document imaging in office 2007
    By DANIEL 602 in forum MS Office Support
    Replies: 3
    Last Post: 05-11-2006, 09:32 PM

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
  •  
Page generated in 1,711,695,184.62404 seconds with 17 queries