Pages

Search

Microsoft Word - Lost Word Document Last Saved on Server

Microsoft Word - Lost Word Document Last Saved on Server

Lost Word Document Last Saved on Server

Posted: 20 Feb 2014 01:40 PM PST

I was working on a word document that was saved to a server.  The endnote in text citation function crashed and closed my document.  I re-opened word and saw the auto-recover document.  I tried to open this document without realizing that my server permissions had expired (we have to periodically re-log in).  An error popped up saying access was denied and the autorecover doc closed and is no longer visible.  Is there a way to still recover this document or are the changes I had made gone forever?  Most of the suggestions I have found refer to when this happens with a doc saved on the actual computer and those suggestions have so far not worked.

Any explanation for the strange behavior of Find and the application of bold to paragraph marks before a table in Word?

Posted: 20 Feb 2014 01:13 PM PST

This strange behavior happens in both manual searches and in VBA using a range-based search. (Well, at least it is consistent in that regard!)

Please excuse the long explanation, but it is a strange behavior! And maybe it is well-known to a few.

Here is the structure of a simple Word document with paragraph marks shown:

----

This is paragraph 1 with some bold text but with the paragraph mark not bolded.¶

This is paragraph 2 partially bolded and with the paragraph mark also bolded.¶

This is paragraph 3 partially bolded and with the paragraph mark also bolded and with a table (not bolded) immediately after.¶

[Table here]

This is paragraph 5 (4 being the paragraph mark after the table above) all bolded (including the paragraph mark) and with a table (not bolded) immediately after.¶

[Table here]


End of document.¶

----

If I search for just the bold font, here is what happens:

- the bold text in paragraph 1 is found/selected (as expected -- it's just for practice ;-))

- the bold text in paragraph 2 is selected, including the paragraph mark

- the bold text in paragraph 3 is selected, including the paragraph mark (except sometimes!)

- the bold text in paragraph 5 is selected, BUT NOT INCLUDING the paragraph mark; HOWEVER, another execution of the search selects JUST the paragraph mark!

Take away the tables, and you always get the paragraph marks included in the initial selection.

So, in these situations, there seems to be some strange effect of the combination of bold applied to an entire paragraph followed immediately by a table.

Occasionally, I have had the paragraph mark excluded from the initial selection in paragraph 3, but I have not been able to reliably replicate that situation.

I have tried applying the bold before creating the tables, and creating the tables after the bold has been applied -- most of the time it doesn't make a difference, but once or twice it seemed that it might have (at least, as explained, the paragraph mark in paragraph 3 was excluded from the initial selection). I have created numerous new documents for testing, so as to avoid any "corruption" from one test to another, but except for the inconsistency that I cannot reliably replicate, all tests exhibit the same behavior.

So ... what practical effect does this have (besides the inconsistencies)?

I am substituting <b>...</b> around the bolded text, except that first I unbold any bolded paragraph marks (including if they result from bold in a paragraph style). BUT when the paragraph mark in paragraph 5 is unbolded, it seems to "back up" the bold selection one character so that the initial selection of the entire paragraph excludes the last character before the paragraph mark!

The result is that I get these "double bold codes" at the ends of some paragraphs: some <b>bold text</b><b>.</b>¶

Easy enough for me to fix in this context, but someone thinking they were getting all the text in the paragraph via one selection or range in VBA would get a nasty surprise!

If anyone has an explanation for this strange behavior, I would appreciate it.

As far as fixing it is concerned, I expect it is just another of the many "bugs" in Word -- many documented 20 years ago and still not fixed -- that we will have to live with. The backwardness of "backward compatibility"!

Style - Using Page Break Before AND Spacing Before Paragraph

Posted: 20 Feb 2014 01:04 PM PST

I am trying to create a set of styles in Word 2013 that can be used by everyone in the office. We want our documents to be set up so that Sections 1.0, 2.0, etc. are always on a new page and have a 48 pt spacing above them, to make the section titles really pop! We want the rest of the headings (Section 1.1.1 etc.) and the body of the text to appear against the upper margin. 

I have made 'Heading' styles in addition to styles for the main body of the text. When creating the style for the Section 1.0 headings, I formatted the paragraph to have 48 pt spacing before, and checked the box "Page Break Before". However, the 48 pt spacing will not show up no matter what I do. It goes to the next page and is placed next to the upper margin. All the solutions I've found are for other versions of Word that do not work for the 2013 version.

I don't know if this is affecting it, but I also created a Multilevel List that links each level to a specific style, which is how I get the 1.0, 1.1, 1.1.1 etc. to automatically show up for each section heading and subheading.

How do I get the space before the paragraph to show up???

Merging Excel Data Across Multiple Word Templates

Posted: 20 Feb 2014 12:16 PM PST

I have a report I run periodically that outputs data to an excel sheet in format "name" "value" "value" all in individual columns (i.e., column a, b, and c).  I use the data from this excel to update multiple word templates, which have an embedded table in the same format as the excel.  Is there a way to link the data from the master excel sheet to update these word documents so I don't have to manually?  So, say I have 20 word documents I need to update with updated values from this report I run, instead of manually going in and copying/pasting individually, can I merge the data or link it so I can just run the report and the word templates automatically pull in the new data?  I've played with mail merge but I'm not sure that is the best option.  Any advice is much appreciated.  TIA

Unable to start an Office 2013 application

Posted: 20 Feb 2014 11:41 AM PST

When I try to start an Office 2013 application, I receive an error that it stopped working. What should I do?

Word 2013 - Slow startup ( links with xlsx )

Posted: 20 Feb 2014 10:57 AM PST

Here's our workstation configuration :

- Windows 7 professionnal 32Bits SP1 fully patched.

- This problem is independent of the workstation configuration ( happens on more than one computer: core i7,i5,i3 ).

- This is not network related since i tested the file opening locally.

- Running in a Novell environnement ( Zenworks 11.2.3a , Novell Client 2 SP3 IR4 )

- Antivirus Eset NOD 5

Here's the problem :

While trying to open a .docx file with about 20 links to charts contained in 2 specific .xlsx files worksheets the waiting time is about 2 minutes before we can do anything.

What has been tried :

- Copy the files from the network to local folder (.docx and .xlsx) and remake the links.

- Tried disabling hardware acceleration.

- Tried disabling all the plugins ( Druide Antidote, SyGED )

- Tried to disable all form of automatic links update on startup.

- Tried to disable ESET NOD Antivirus.

I'm a little out of option here, is there a KB out there that could speed up the word opening process ?

Thank you !

Help opening a word doc without editing

Posted: 20 Feb 2014 09:52 AM PST

When I try to open a PDF document of any kind word wants to convert it to an editable word document and I do not want it to open them this way. I want them to open in the original format and then I can convert later if needed. Please help.

Word 2010 Home Version won't start

Posted: 20 Feb 2014 09:16 AM PST

Word 2010 Home Version will not start.  This includes excel.  When I did a repair I got a error message "Click-2 Run configuration failure".  Please advise.

Remove multiple pages from multiple documents

Posted: 20 Feb 2014 09:06 AM PST

If I have 50 documents and I need to remove the first 5 pages of each document, what would you suggest as the most efficient method for doing this?

Is it possible to create a macro? Do you know of a program that would help me? Any help would be appreciated!

Issues with Search and Replace Straight Quotes to Smart Quotes

Posted: 20 Feb 2014 08:04 AM PST

Has anyone had issues where Word turns the end quote backwards when it appears after cross-referencing codes?

Spelling and grammar "settings" button not active

Posted: 20 Feb 2014 07:52 AM PST

I purchased Microsoft Office 2010 and got three licenses to download the software to 3 different computers.  I downloaded the Office software on my desktop (Windows XP) and my laptop (Windows 7).  For some reason the "settings" button under "When checking spelling and grammar in Word" is grayed out on my laptop but it is fully functional on my desktop.  Why is it grayed out on my laptop and how can I get it to become functional?

Selecting part of a table, then remove or relace

Posted: 20 Feb 2014 07:51 AM PST

Hi,

I have a word document that is made up of several tables.

I would like to be able to select a number of Rows in a table that my cursor is currently in.

I have several Tables so I cannot use .Tables(1) as I am not in that table, so what I want to do is say I am in Table 5, Cell 11, 3, I would like to have the cursor move to Cell 4, 1, in that table and then select all the Rows below of this table (ie 4, 1 to 10, 3) I think its .EndOfTable?

Please check my Add Row section is Right?

Please note that I don't want it to be seen what is happening, so I have turned off Screen Updating, but I think the Macro needs to be set to use Ranges and not Selection.

Here's my current Macro...

Sub Programme_Finished()
'Format the Programme Finished

    'System Settings
    StatusBar = "Please Wait...  Making Changes to the Vurrent Table..."
    Application.ScreenUpdating = False

    'Select the Rows of the Current Table Your In

    Help Here

    'Delete the Rows

    Help Here

    'Add Row
    With Selection

        'Create the Row
        .MoveRight Unit:=wdCell

        'Select the New Row
        .MoveRight Unit:=wdCharacter, _
            Count:=3, _
            Extend:=wdExtend

        'Fill the New Row 'RED'
        .Cells.Shading.BackgroundPatternColor = wdColorRed

       'Set the New Row Height
        .Rows.HeightRule = wdRowHeightAtLeast
        .Rows.Height = CentimetersToPoints(0.5)

        'Merge the 3 Columns
        .MoveLeft Unit:=wdCharacter, Count:=1
        .MoveRight Unit:=wdCharacter, Count:=1
        .Cells.Merge
        .ParagraphFormat.SpaceBefore = 0

        'Set Font Format
        With .Font
            .Name = "Poor Richard"
            .Size = 10
            .Bold = True
            .Italic = True
            .Color = -603914241

            'Enter Text
            .TypeText Text:="This Programme has Finished!"
        End With
    End With

    'System Settings
    Application.ScreenUpdating = True
    StatusBar = ""
    ActiveDocument.Save
End Sub

Thanks,

Neil

Change Selection to Range in Macro

Posted: 20 Feb 2014 07:23 AM PST

Hi,

I have a Macro that will sort a table then make changes to it.

The problem I have is that I have turned off screen updating, but I can still see the screen changing.

I believe that I've been told that if I use Range instead of Selection than I should not see any changes,

but the problem I have is that I don't know how to change the Macro from Selection to Range.

Please if you have the time, can you look at the Macro that I have inserted below and let me know the changes I need to make.  I think the problem is in the Sort part of the Marco but may also have other places that need to be changed.

I also on some of the tables have a row that holds the information for the last Episode information of the pervious Season, but I don't want this to be included in my totals.

So what I need to do is if CELL(4,1) contains 'S' and 'Ep.' acturally as "Sn, Ep.n" Please note that S is Season and Ep. is Episode and n's could be between 0 to 999.  What I have tried but does not work is in BOLDITALIC in the Macro?

Here's my Macro...

Sub Sort_HDD_Programme_List()
'Sort HDD Programme List

    'Settings...
    Dim styStyle As Style
    Dim WhichRow As Long
    Dim WhichTable As Long
    Dim Episodes As Long
    Dim Recorded As Long
    Dim Watched As Long
    Dim NumberOfCharacters As Long
    Dim ProgrammeInformation As String
    Dim ProgrammeName As String
    Dim ProgrammeNameCheck As String
    Dim SSeries As String
    Dim ESpace As String
    Dim WSpace As String
    Dim RSpace As String
    Dim TSpace As String
    Dim EndOfCellMarker As String
    Dim Find1 As String
    Dim Find2 As String

    'Defaults
    EndOfCellMarker = Chr(13) & Chr(7)
    Find1 = "S"
    Find2 = "Ep."

    'System Settings
    StatusBar = "Please Wait...  I'm Sorting Programme(s)..."
    Selection.HomeKey Unit:=wdStory
    Application.ScreenUpdating = False

    'Change Font Style
    With Selection
        .HomeKey Unit:=wdStory
        .Tables(1).Select
        With .Font
            .Name = "Arabic Typesetting"
            .Size = 10 '12
        End With
    End With

    'Do Sort...
    StatusBar = "Please Wait...  I'm Sorting Programme(s) that You've Seen..."
    ActiveWindow.ActivePane.View.ShowAll = Not ActiveWindow.ActivePane.View.ShowAll
    Selection.Sort ExcludeHeader:=False, _
        FieldNumber:="Column 1", _
        SortFieldType:=wdSortFieldAlphanumeric, _
        SortOrder:=wdSortOrderAscending, _
        FieldNumber2:="", _
        SortFieldType2:=wdSortFieldAlphanumeric, _
        SortOrder2:=wdSortOrderAscending, _
        FieldNumber3:="", _
        SortFieldType3:=wdSortFieldAlphanumeric, _
        SortOrder3:=wdSortOrderAscending, _
        Separator:=wdSortSeparateByCommas, _
        SortColumn:=False, _
        CaseSensitive:=False, _
        LanguageID:=wdEnglishUK, _
        SubFieldNumber:="Paragraphs", _
        SubFieldNumber2:="Paragraphs", _
        SubFieldNumber3:="Paragraphs"
    ActiveWindow.ActivePane.View.ShowAll = Not ActiveWindow.ActivePane.View.ShowAll

    'Delete Hyperlink Style if it Exist...
    For Each styStyle In ActiveDocument.Styles
        If styStyle.NameLocal = "Hyperlink" Then
                If styStyle.InUse Then
                    styStyle.Delete
                Exit For
                End If
        End If
    Next

    'Create Information for all Programme
    StatusBar = "Please Wait...  Updating your Index..."

    'Collecting Information
    With ActiveDocument
        For WhichTable = 2 To .Tables.Count
            Episodes = 0
            Recorded = 0
            Watched = 0
            With .Tables(WhichTable)

                'If the Last Episode of the Last Season is in Row 4, Column 1
                '.Cell(4, 1).Find.Execute Findtext:=Find1 & "*" & Find2 & "*" & EndOfCellMarker, MatchWildcards:=True
                'If .Find.Found Then
                    'Episodes = Episodes - 1
                'End If

                For WhichRow = 4 To .Rows.Count

                    'Get Total Number of Episodes
                    If Len(.Cell(WhichRow, 1).Range.Text) > 2 Then
                        Episodes = Episodes + 1
                    End If

                    'Get Total Number of Episodes Recorded
                    If Len(.Cell(WhichRow, 2).Range.Text) > 2 Then
                        Recorded = Recorded + 1
                    End If

                    'Get Total Number of Episodes Watched
                    If Len(.Cell(WhichRow, 3).Range.Text) > 2 Then
                        Watched = Watched + 1
                    End If
                Next WhichRow
            End With

            'Get Programme Name
            ProgrammeName = Mid(.Tables(WhichTable).Cell(1, 1).Range.Text, 1, _
                Len(.Tables(WhichTable).Cell(1, 1).Range.Text) - 2)

            'Get Series/Season Number
            Series = Mid(.Tables(WhichTable).Cell(2, 1).Range.Text, 8, _
                Len(.Tables(WhichTable).Cell(2, 1).Range.Text) - 9)

            'Working Out Spaces...
                'for Series/Season Number
                If Series < 10 Then
                    SSeries = " "
                Else
                    SSeries = ""
                End If

                'for Number of Episodes
                If Episodes < 10 Then
                    ESpace = " "
                Else
                    ESpace = ""
                End If

                'for Number of Watched
                If Watched < 10 Then
                    WSpace = " "
                Else
                    WSpace = ""
                End If

                'for Number of Recorded
                If Recorded < 10 Then
                    RSpace = " "
                Else
                    RSpace = ""
                End If

                'for Number to Still Watch
                If (Episodes - Watched) < 10 Then
                    TSpace = " "
                Else
                    TSpace = ""
                End If

            'Check to see if this Programme is the same as last Programme entered?
            If ProgrammeNameCheck = ProgrammeName Then
                GoTo NextProgramme
            End If

            'Set Programme Information to...
                '(This Programme has Finished!)
                If Mid(.Tables(WhichTable).Cell(2, 1).Range.Text, 1, 28) _
                    = "This Programme has Finished!" Then
                        ProgrammeInformation = "(This Programme has Finished!)"
                Else

                '(Series: nn ~ Rec'd: nn/nn ~ Seen: nn/nn)
                    ProgrammeInformation = "(Series: " & SSeries & Series & ", Rec" _
                        & Chr(146) & "d: " & RSpace & Recorded & "/" & ESpace & Episodes _
                        & ", Seen: " & WSpace & Watched & "/" & TSpace & Episodes & ")"
                End If

            'Find Programme in Index
            With Selection
                .HomeKey Unit:=wdStory
                With .Find
                    .ClearFormatting
                    .Text = ProgrammeName
                    .Replacement.Text = ""
                    .Forward = True
                    .Wrap = wdFindContinue
                    .Format = False
                    .MatchCase = False
                    .MatchWholeWord = True
                    .MatchWildcards = False
                    .MatchSoundsLike = False
                    .MatchAllWordForms = False
                End With
                .Find.Execute
            End With

            'Add or Change Programme Information
            With Selection
                .MoveRight Unit:=wdCell
                .Text = ProgrammeInformation
                .Font.Hidden = False
                .MoveRight Unit:=wdCharacter, Count:=1
            End With
            NumberOfCharacters = Len(Selection.Cells(1).Range) - 4
            With Selection
                .MoveLeft Unit:=wdCharacter, Count:=1
                .MoveLeft Unit:=wdCharacter, Count:=NumberOfCharacters, Extend:=wdExtend
                With .Font
                    .Name = "Arabic Typesetting"
                    .Size = 10
                    .Italic = True
                End With
                .ParagraphFormat.SpaceBefore = 2
            End With

            'Check if the next Programme is the same as last Programme entered
NextProgramme:
            ProgrammeNameCheck = ProgrammeName
        Next WhichTable
    End With

    'Home
    Selection.HomeKey Unit:=wdStory

    'Settings
    Application.ScreenUpdating = True
    StatusBar = ""
    'ActiveDocument.Save
End Sub

Thanks,

Neil

Reference Style Editing

Posted: 20 Feb 2014 07:11 AM PST

In my work I use to cite articles, books, etc in my Word files. However, when it comes to finish the document and give the right format to citations, I have to convert everything to text and erase parenthesis one by one in the text and rearrange the bibliography manually because none of the styles provided by Word fulfills the requirements of my "clients".

Is it possible to change the format of the referencing style (in a user-friendly way)? For example, How could I switch Author-Title-Year to Author-Year-Title? How could I add an in-line citation like "Smith (2012) said that..." instead of "(Smith 2012) said that..."?

Thanks.

Getting the Accounting Format in a Table Cell

Posted: 20 Feb 2014 06:53 AM PST

Hello,

 

Is there an option in word for me to format numbers in a cell as an accounting format like in Excel?  Meaning that my $ is to the absolute left of the cell & I do have commas every 3 integers.

Frustration in Formatting Word Columns & Rows in a Table

Posted: 20 Feb 2014 06:51 AM PST

Hello,

 

I work in financial reporting & I spend a lot of time with word tables.  It makes me slightly ill when I think about how much time I've spent trying to fix formatting issues where the table has become too big for word & autofit will start to wrap numbers so that it would look like the following:

$1,000,0

00,000

 

When I want to it fit nicely in one cell as $1,000,000,000.  I will spent lots of time fiddling with font size & column widths to get my numbers to fit & not have wrap text.  Is there a better way to work with word tables?

Why is the show margins button missing in word 2013 print preview?

Posted: 20 Feb 2014 06:37 AM PST

The zoom bar and Zoom to Page button are there, but the Show Margins button is not. I have searched through every option in Word 2013 and I cannot find a way to turn it on, I am extremely frustrated. I am using Office Home and Business 2013 version 15.0.4454.1510 on windows 8.1.

Intermediate Document Save As Dialog Box

Posted: 20 Feb 2014 06:36 AM PST

I'm hoping someone can assist me, seems I've turned on an option and cannot figure out how to turn it off.  When I do a "Save As" in Word 2013 I get an intermediate dialog box before it brings up my drives to save the document.  How can I turn this off, I don't remember it being on prior and it's driving me nuts.  Below is the screen shot of the box.  Thanks in advance for any assistance.

Office Online create regionalized version of "Documents" file

Posted: 20 Feb 2014 06:12 AM PST

Whenever I try to start a "new document" in the new Office Online (office.com page), Word, Excel, and PowerPoint create new documents in an Arabic-version folder: "المستندات" for Documents. I have switched my regional settings to English/United States in my Live account, Xbox account, billing options, and anywhere I can find it, but whenever I delete this folder and start a new document, documents go into this Arabic file instead of "Documents".

Is this a OneDrive issue or a Office Online issue?

Any advice?

Add an item to a custom Ribbon tab *WITHOUT* an icon

Posted: 20 Feb 2014 05:52 AM PST

I've created a custom tab and groups in the Word 2010 ribbon.

I want to be able to add items to each group WITHOUT any icons - just text.

Thoughts/Solutions?

Thanks a bunch!!!

Word 2013: Rearranging rows/columns in tables

Posted: 20 Feb 2014 05:52 AM PST

I know this question has been asked in the past and not answered. I am so frustrated I could scream (in fact, I have).

I need to easily rearrange rows and columns in my tables (which, as a quantitative researcher, I have to work with daily). I recently installed Windows 8.1 and now the tables in Word 2013 are not behaving the way I'm used to.

Whenever I try to rearrange my table rows or columns by clicking and dragging to the new spot, the row where I wish to insert is now replacing my old information, which I do not want! I seriously don't have time to keep adding a row, copying the information, pasting it to the new row, and deleting the old row. This is very cumbersome, time consuming, and inefficient. My production level is seriously suffering at this point. Is there a way to change to this in Word 2013?

I am begging for help here!

Thank you in advance,

Liz

Corrupted .docx file

Posted: 20 Feb 2014 05:51 AM PST

I accidentally deleted the contents of an SD card I had, so I ran data recovery and got all the files back, but a few of the word documents were corrupted. I did a decent amount of Googleing but couldn't find any fixes that worked. Please help. I can send you the files if I need to, but I'd rather not. Thanks.

Word stops responding when a new autor is added

Posted: 20 Feb 2014 02:04 AM PST

Word stops responding when a new autor is added to the existing ones.

Could someone from the Office team have a look at that?

Thanks

Word cannot open document template ~$ilding.dotx

Posted: 19 Feb 2014 07:00 PM PST

When I tried to Insert>Quick Parts, I would get the message "Word cannot open document template ~$ilding.dotx". I finally found this file in C:\Users\Owner\AppData\Roaming\Microsoft\Document Building Blocks\1033\ and deleted it. The problem was solved. Search functions would not find the corrupted file.

Mail Merge via Outlook

Posted: 19 Feb 2014 06:01 PM PST

Is it possible to send a mail merge through outlook with both a personalised attachment and text in the body of the email?

Create a Table in WORD 2010

Posted: 19 Feb 2014 05:19 PM PST

In WORD 2010: format cells to make equalateral squares?

Make a border appear only at the bottom of a table row that spans pages

Posted: 19 Feb 2014 04:31 PM PST

I have a 2 column table in Word 2010 with a row that runs on to the next page. I apply a border to the bottom of that row and the border appears where I want it but also at the bottom of the prior page through the middle of the cells. I appended a row to the table and applied a border to the top of the new row and got the same results. If I apply the border to the bottom of the new row, that works but that leaves a gap between the border and the cell contents. Is there a way to make the border appear at the bottom of the row only? Thanks in advance.