Fix – MS Word has Different Headers on Pages and Linking Doesn’t Work

Picture of Header, Heading Text and Paragraph Text with Section Break

How to Fix Broken Headers

The Fix:

Link to Previous Menu Option in WordWe need to link each header from each section back to the original header (or footer).  After each section break we will need to insert a new page (Ctrl-Enter for shortcut).  Once each section is on its own page, we can edit the header (or footer) for that section.  Double click on the header to go into the edit header/footer mode.  The design tab (of the ribbon) should have the focus and you should see a navigation pane with a “link to previous” option.  Click it to link the current header to the previous header.  Do this for each section that you have given its own page (Ugh!).

Once you fix the headers, you can test them by typing in a letter or number in one header and scrolling through the pages to make sure it shows up on all the pages.

Once you are satisfied that the headers (or footers) are fixed, you can delete each of the new page returns.  (Use the paragraph symbol on the Home tab to show them, if you have difficulty).

The Problem:

I have a bunch of continuous section breaks in my document, each seems to have its own heading.  As I edit the document, my headers disappear or change.

What is Happening:

This is due to the fact that each section can have its own header attached.  So if I have a bunch of continuous sections on a page that I have copy/pasted from elsewhere with their own headers (not linked), then Word will select one of the section headers (I think the top one) and use it for the page header (and/or footer).

 

Hope this helps!

–Ben

Sources:

Trial and Error and a few choice words.

Fix – MS Excel – Cause PivotTable to Refresh When New Data is Entered

The FixRefresh-PivotTable

  1. Right Click on your pivot table report tab
  2. Select the view code menu item
  3. Add the code snippet below (assuming that the Pivot Table is the first or only pivot table on the page) in the box
  4. Click on the Save button at the left of the window
  5. Close the code window.
  6. Every time you click on the worksheet tab, the table will refresh.
Private Sub Worksheet_Activate()
 Me.PivotTables(1).RefreshTable
End Sub

The Problem

I was helping my brother in law work on a master spreadsheet that listed the various jobs that were being worked on.  I created two pivot tables that filtered the jobs by the person who was working on it.  However, when the master list was updated, the pivot tables were not refreshing.  To work around it, he was exiting and then opening the file again.  Yuck!

What is Happening

The bit of code is telling the first pivot table on the worksheet tab to update when the worksheet is accessed (i.e. activated).

Hope that helps!

–Ben

Sources

Microsoft Technet Post by Hans Vogelaar

NextPageSectionBreak

Fix – MS Word – Remove Next Page Section Breaks – Get Rid of the Blank Page

Word Logo with PainUPDATE 10/10/2014: See update for a potential better way to fix stubborn next page section breaks that won’t delete.  Thanks CherryBerry!

Problem: Word has an extra page at the end that you can’t delete, and when you turn on the Show/Hide codes function a “Section Break (Next Page)” appears after your text.  In fact, every time you delete the Next Page Section Break, text moves to the last page.

Solution: Click after the section break (i.e. on the last page).  Go to File -> Page Setup … in the menu (in XP – in Later Versions, go to page setup). Click on the layout tab in the pop-up window.  Change the Section Start from “New Page” to “Continuous” using the drop down arrow.  Hit the OK button.  Phew!  See the Graphic to the Right

What happened: I have no idea.  But this allows you to change a section break’s behavior.  It appears that Word is insistent on always moving back any Next Page Section breaks if deleted.   However, if you change the behavior of the current break, its OK.

Hope that Helps.

–Ben

Sources: See Suzanne S. Barnhill’s comment on Wugnet

UPDATE 10/10/2014:

DraftButtonCherryBerry made a great comment below that fixes some of the more persistent next page section breaks:

“At the bottom-right corner of the window next to the size slider, there should be 5 icons. Click on the one closest to the slider, when you mouse over it, there should be a label thing saying “Draft”, click on that icon. there should be text saying “::::::::::::::::::::::::Section Break (Next Page):::::::::::::::::::::::::::”. Delete them.”

I’ve included a picture to show the draft button at the bottom right of the window.

Thanks CherryBerry!

–Ben

Fix – Use Cross Reference to Reference a Sequence/List of Items in MS Word

Word Logo with PainProblem – I had a list of claims in which I wanted a cross-reference to work in a cross reference window.  The fields were there, highlighted as field codes, but the claims didn’t show up in the cross-reference window.

Fix – Right click on the field and click “toggle field codes.”  Note the name after the “SEQ” or other three letter beginning.  Go to Insert -> Reference -> Caption.  Click on “New Label” button.  Add the name as it was spelled after the SEQ. Click OK.  Click Close.  Now go to Insert -> Reference -> Cross Reference and your name is now in the drop down box.  Select the name and you should see your sequence displayed in the main pane in the cross-reference box.  Phew!

Hope that helps!

–Ben

Source:  Comment on The Occasional Tech

RemovePersonalInfoCheckbox

Fix – Make All Track Changes be One Reviewer

Word Logo with PainProblem:

You’re at work and you and several reviewers have made changes to a document using track changes.  However, you don’t want to send the client a document showing internal editing, but just a coherent single author track changes document.

Solution:

You remove the author information in the privacy settings and all track changes show as one author.  In word 2003, it is under the menu Tools -> Options -> Security Tab -> “Remove personal information from file properties on save” checkbox.

DANGER:

Changes are still tracked.  So it looks like the editor corrected him/herself.  You will need to accept deleted insertions.

Hope that helps.

–Ben

Adobe Acrobat Std

Fix – Adobe Acrobat Opening Multiple PDF Files Instead of One Problem

Problem: When my boss started up his computer and/or clicked on a PDF file, he would have multiple PDF windows open.  It was almost like his computer was opening every PDF he had opened before.

Fix: Run disk cleanup in windows.  I’m told that on a mac, you should remove (and backup) a file called com.adobe.acrobat.90.sh.plist from the preverences folder.

 

 

For the windows solution:

  1. Open the disk cleanup tool by going to Start -> All Programs -> Accessories -> System Tools -> Disk Cleanup
  2. Choose “Files from all users on this computer”
  3. Click Continue (if you have user access controls enabled – probably)
  4. Choose the C: drive and wait for it to finish
  5. Leave the default checked boxes (although you could try checking everything) – BE AWARE that this step will delete stuff.  Make sure you didn’t want anything its going to delete.
  6. Click OK
  7. Click Delete Files (if you’re sure) and wait for it to finish.
  8. Try to open a PDF file.

What Happened: I’m not sure.  However, I suspect there was a temporary file or command line argument that should have been deleted, but got left alone.  Every time adobe acrobat (or adobe reader) started, it was fed that information and told to open those files.  This is normally useful, as when you click on a file, that filename is provided to acrobat or reader.  However, if the system doesn’t forget that filename, but instead adds to it – you can end up with multiple files opening.  I don’t know where those temporary files reside.  However, a disk cleanup seems to wipe them out.

Hope that helps,

–Ben

Disk Cleanup Page, Adobe Forum on a Similar Mac Problem, Techarena Forum (just note that deleting the recent file list didn’t fix it for me)

 

PCLaw Icon

Fix-PCLaw Crash 9.10b-Windows Accounting Software for Lawyers has stopped working

PROBLEM: PCLaw crashes right after you type in your password to your books.  In no way can you login.  You get the error message that “Windows Accounting Software for Lawyers has stopped working.”

 

FIX: Uninstall Internet Explorer 9, which should roll you back to Internet Explorer 8.  PCLaw cannot function with Internet Explorer 9 unless you have PCLaw v10 Service Pack 5 Hotfix 3.  Here’s the steps:

  1. Go to the Control Panel
  2. Go to Programs and Features
  3. Click on Installed Updates (in the left pane)
  4. Look under the Heading “Microsoft Windows”
  5. Right click on Windows Internet Explorer 9
  6. Select Uninstall
  7. Click Yes
  8. Click Continue
  9. Restart Your Computer

Explanation: PCLaw most likely uses Internet Explorer for some things under the hood.  Apparently IE 9 breaks compatibility with the functionality of older versions of IE.  Luckily, it looks like those who run XP will not be hit by the problem, as IE 9 won’t run on XP.

 

Hope this helps,

–Ben

Sources:  Lexis PCLaw, Affinity Consulting, Microsoft Windows Support, Computerworld

Utah Genius Logo

Turn a Picture into a Website with Free Image Map Tool – CSS Support Too!

I’m currently working with a company on the Utah Genius Website.  I needed a layout quickly, as our invitations were about to be sent out.  The company had used photoshop to do a proof of the layout, and we had settled on a good front page.  They gave me the JPG to use as a placeholder while they created the HTML and CSS.

So I put up the image and dreaded making an image map for it.  Luckily, I found a tool that would do HTML or HTML & CSS image mapping for me.  Its called image-maps.com.  It was quick, could work off of an online or uploaded image and gave me the code to modify at my whim.

They requested a donation, blog post, and link back.  However, none were required.  I decided to give the blog post (this post) and the link back, as its unobtrusive.

Thanks guys!

–Ben

Source:  UtahGenius.com, Image-Maps.com

Fix – Office XP opening DOCX, XLSX files – Compatability pack broken

Word Logo with PainPROBLEM:

If you’re like me, you discovered that the compatability pack for Office XP broke sometime earlier this year.  You can’t open DOCX or XLSX files from outlook.  You get a strange bunch of errors when opening DOCX and XLSX files and end up opening a file with a strange name in the temporary directory when it works.

FIX:

You have 3 choices:

  1. upgrade to Office 2007 or 2010;
  2. roll back update kb981715; or
  3. find and install a prior version of mso.dll (not recommended).

I chose option 1, as it was was 160 bucks on newegg.  Totally worth more than it would be to dig and fix.  (it also requires a download of the install file, as there is no media)

As to option 2, rolling back the update can be difficult, because I couldn’t find the update.  I didn’t dig, but it may be included in a service pack or corrected by another update.

As to option 3, I don’t recommend it because dll’s frequently have to be registered on the system.  A find and replace could have very bad effects on your office – even breaking it.

WHY:

MS replaced mso.dll in the update.  However, as far as I can tell, permissions in Vista are messed up.  The program does not have the ability to fix bad registry settings and so ends up in a bad state.  The workarounds that I’ve been reading about sound arduous and annoying, if they work.  As Office XP is 8 years old, I’m guessing good old M$ doesn’t care if the old version is broken.

Hope that Helps.

–Ben

Sources:  Allen Browne; The Daily Reviewer; Geekpedia

Laser Printer

Fix – Move a Print Job from an Offline Printer to Online Printer when In the Spooler

Fix:  Change the Offline Printer’s Port to an Online Similar Printer’s Port.  As far I can tell, you can’t move the file / print job.  You can just trick the spooler to use a different port which is connected to a different printer.

  • Find a printer that is the exact same model (or very, very close).
  • Connect it to the computer and get it set up.
  • Go to Printers in the Control Panel.
  • Right click on the new Printer and select Properties.
  • Click on the Ports Tab.
  • Look at its port. (You may have to widen the column)
  • Right click on the offline printer and select Properties.
  • Click on the Ports Tab.
  • Check the Box on the port that matches the new Printer’s Port
  • Click Apply.
  • Click OK.
  • Right Click on the Offline Printer and say Use Printer Online
  • Click on the Printer Menu
  • Click on the Pause Printing Item (to uncheck it … If there’s no check leave it alone)
  • Watch as the Print comes Out!

Problem:  I had a friend who had printed a success page from a web page that he submitted very important documents.  Unfortunately, he exited the browser before he made sure the printout came out.  Worse yet, the print was assigned to an offline printer that no longer existed (we replaced that printer a while back).  His print job was stuck in an offline printer spooler with no place to go.  He wanted to move the print job from one printer to another printer.

Hope that helps.

–Ben

Source:  Microsoft Answers