|Tags: microsoft office, office 2007|
| ||Thread Tools||Search this Thread|
Cause of Document Not Saved in Microsoft Office
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.
re: Cause of Document Not Saved in Microsoft Office
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.
Dim NewSheet As Worksheet
Dim MySheet As Worksheet
Dim myshape As Shape
Dim I As Long
Set MySheet = ActiveSheet
Set NewSheet = Worksheets.Add
.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
.Range("A1:C1").Font.Bold = True
.Range("A1:C" & Rows.Count).Sort Key1:=Range("C1"), _
|Thread Tools||Search this Thread|
|Similar Threads for: "Cause of Document Not Saved in Microsoft Office"|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Microsoft Office Document Imaging||Christopher||MS Office Support||4||09-12-2010 08:25 PM|
|Office 2010,Excel document not getting saved||Parvati||Operating Systems||3||27-10-2010 12:52 AM|
|Microsoft Office Document Scanning||Moiz||MS Office Support||3||04-06-2010 07:49 PM|
|Does Office 2007 contain Microsoft Office Document Imaging?||m3pilot||MS Office Support||3||30-12-2009 07:54 AM|
|microsoft office document imaging in office 2007||DANIEL 602||MS Office Support||3||05-11-2006 08:32 PM|