Difference between revisions of "Microsoft Office"

(→‎PowerPoint for Windows: - consolidation)
m (Updated lynda course link to LinkedIn Learning)
(58 intermediate revisions by 9 users not shown)
Line 1: Line 1:
== Microsoft Office for Windows - General ==
'''Related link:''' [[Find_Microsoft_Office_Version_Information|How do I find my MS Office Version?]] <br><br>
Information Technology Services (ITS) began installing Microsoft Office 365 on computers provided during the staff upgrade process in spring 2019.
=== Corrupted install  ===
=== Installation Details ===
===== College-Owned Computers =====
Microsoft Office 365 is available for self service installation on both Mac and Windows '''college-owned''' computers.  <br><br>
Case: when you try to start Word, you get an error msg: "Word has failed to start in safe mode. Do you want to try to repair your installation?"
Refer to the appropriate link below for installation instructions:
* '''Windows:'''  Install "Microsoft Office 365 ProPlus" via [[KACE_FAQ#How_do_I_use_KACE_Self_Service_to_install_software_on_my_Windows_computer_myself.3F|KACE Self Service]].
* '''Mac:''' Install "Microsoft Office 365 for Mac" via [[JAMF_Pro_Self_Service_FAQ#How_do_I_use_Self_Service_to_install_software_on_my_Mac.3F|JAMF Pro's Self Service]]  -- requires OS 10.12 (Sierra) or higher; OS upgrades are also available via the Self Service utility.
Reason for this is unknown. Solution is simply to click through the messages to repair / "clean" your MS Office installation; in at least some cases, you do not even need the Office install CD to do so.
===== Personally-Owned Computers =====
[http://go.middlebury.edu/o365 Office 365] is available for installation on personally-owned computers.  Visit [https://support.gmhec.org/TDClient/47/middlebury/KB/ArticleDet?ID=142 Microsoft Office for Personal Computers] for details.
MS Office versions don't always line up perfectly. Even if it says "MS Office Pro 2003", doesn't mean that your MS Office Pro 2003 disk will be able to do a repair install. In many of these cases, the only fix is just to remove Office and reinstall it from scratch, making any needed modifications.
=== How to Learn More about Office 365 ===
=== Cannot open older files  ===
Office 2003 SP3, as well as Office 2007 will refuse to open documents created with very old versions of MS Office. There is a fix.
# Close all word documents and windows.
# Click on Start =&gt; Run
# Enter this text: <pre>\\snowleopard\vol1\Software\Software-Windows\Quick-Fixes\FIX-OF03-OF07-open-blocked-files.reg</pre>
# Click OK, then when asked "Are you sure you want to enter this information?", click YES.
# Click on Start =&gt; Run:
# Enter this text: <pre>\\snowleopard\vol1\Software\Software-Windows\Quick-Fixes\</pre>
# Click OK. In the folder that opens double-click FIX-OF03-OF07-open-blocked-files.reg, then click Yes.
=== Proofing Tools  ===
In the US English version of Office 2003, only English, Spanish and French proofing tools (spell/grammar checks) are available. For details see [[Proofing Tools That Come Standard in Office 2003]]
[[What Proofing Tools are Standard in Office 2003]]
=== File formats in Office 2007 ===
By default, Office 2007 programs will save in an Open XML format. At a glance, it simply looks as though all they did was add an extra 'x' at the end of all the existing file extensions:
*.doc =&gt; .docx
*.xls =&gt; .xlsx
*.ppt =&gt; .pptx
The new format is incompatible with Office 2003. People should '''avoid saving in this (default) format'''. To ensure compatibility on documents that you intend to work on with other computers or collaborative works, save files using the ''office 97-2003'' format. This can be done by changing the format to the ''Office 97-2003'' format in the dialog box at the time of saving. You may also change the default saving format from the ''open XML'' to ''office 97-2003'' in each application. This can be done by:
*Click on the office button
*Select O options (where O is the name of the program you are working in)
*Select save and for save format, select the ''O 97-2003 document''
If user needs to open a .docx file, [http://www.microsoft.com/downloads/details.aspx?FamilyID=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en MS Office 2007 Compatibility Pack] can be installed (requires MS Office). Alternatively, [http://www.openoffice.org/ OpenOffice.org] version 3 can also view and edit .docx files, although it cannot save to this format.
== Word for Windows ==
=== MS Word freeze-ups  ===
*'''Due to unavailable network printer:''' If a network printer is configured as a default printer and the computer is connected to the internet but the printer is ''not available'' (for example, if the computer is off-campus), Word may hang when you open the Print dialog box. (Acc. some reports, may even cause Word 2003 to freeze on launching.) Solution: change default printer. PDFCreator [http://sourceforge.net/projects/pdfcreator/]?
*'''Due to unavailable mapped network drive:''' In MS Word, when you go to Save As..., Word tries to scan all mapped drives listed in the pulldown menu to determine whether they are available. If a mapped drive can't be reached, Word will keep trying to ping it until it finally times out and gives up - but it doesn't learn from this giving up for next time. Solution: Go to My Computer and unmap any unavailable drives - but make sure the user has a way of getting back to them again. (Shortcut on desktop?)
=== Removing a phantom horizontal rule/bar/line  ===
#Select the paragraph where the horizontal bar appears and click on the "Format" menu, then select "Borders and Shading".
#Click on the Borders Tab.
#Under "Setting", click in on "None", and click OK.
=== How do I turn off the border on a text box in MS Word?  ===
For Office 2003 and earlier:
#Place the cursor inside the text box
#From the Format menu, select Text Box
#Under the "Line" section choose "No Line" from the "Color" dropdown menu
For Office 2007:
#Place the cursor inside the text box
#From the Format tab, select "Shape Outline" and click "No Outline"
=== Remove blue wavy underlines in Word  ===
In Microsoft Word:
*Go to: Tools -&gt; Options
*Click on the Edit tab
*Uncheck the box beside "Mark formatting inconsistencies."
=== Shutting off the Reading Layout view in Word 2003 ===
In Word 2003 How to stop it from opening in the double pane view for proofing or reading (called reading layout).
===== Take a Short Course using LinkedIn Learning: =====
*For '''Windows''' (PC): [https://www.linkedin.com/learning-login/share?account=2213609&forceAccount=false&redirect=https%3A%2F%2Fwww.linkedin.com%2Flearning%2Foffice-365-new-features-microsoft-365%3Ftrk%3Dshare_ent_url%26shareId%3DxZMdWuqfQdG%252B2Gq4veJ7og%253D%253D Office 365 New Features]
#Choose General tab
#Uncheck the box beside "allow starting in Reading Layout"
=== Macros and viruses  ===
Word documents can contain ''macros'' which are small scripts that automatically perform complex or repetitive actions in MS Word. Unfortunately macros can also have extensive control over your computer, so they can be used to write viruses. Any system that can run macros in a MS Word document, is also vulnerable to macro-based viruses. Use and run macros with care.
===== Use Microsoft's Resources =====
* [https://support.office.com/en-us/article/Office-Training-Center-b8f02f81-ec85-4493-a39b-4c48e6bc4bfb?ui=en-US&rs=en-US&ad=US Office Training Center]
=== See also ===
* [https://support.office.com/en-us/article/Office-2016-Quick-Start-Guides-25f909da-3e76-443d-94f4-6cdf7dedc51e Office Quick Start Guides]- both online AND downloadable guides
* [[Unable to see headers and footers in a Word document]]
* [https://support.office.com/en-us/article/Office-2016-for-Mac-Quick-Start-Guides-5bccb480-0e5b-4b51-b072-66d3793ccad8?ui=en-US&rs=en-US&ad=US Office Quick Start Guides for Macs] - downloadable guides
* [[Endnote toolbars not showing in Word]]
* [[Changes to toolbars in Word not being saved]] - this is generally related to Adobe Acrobat Pro being installed.
* [http://office.microsoft.com/en-us/word/HA010983881033.aspx Get rid of Tracked Changes for once and for all]
== Excel for Windows ==
=== Excel is missing all the toolbars and tabs ===
This happens if excel is in fullscreen mode. Until you undo the fullscreen mode Excel will always start fullscreen. You undo fullscreen by clicking View =&gt; Fullscreen.<br>
=== Formatting a list of ID numbers ===
When you enter in a number like 00324328 into Excel, Excel usually deletes the leading zeros because they're "not important". Sometimes those zeros ''are'' important - for example, on a list of Midd student/staff ID numbers. You can set Excel to ''include'' those leading zeros in specific cells with the following steps.
#Click and drag to select the area of cells that you want to show leading zeros.
#Right-click in the selected area and choose '''Format Cells'''.
#Under the '''Number''' tab, choose the Category '''Custom'''. (''In this area, you specify the way you want Excel to show cells. By choosing "Custom", you are saying that you want to manually specify the format to be used.'')
#In the '''Type:''' field, erase the default value "General" and enter in '''00000000''' (eight zeros). (''This tells Excel that every number value in these cells should display with at least eight digits, leading zeros by default.'')
#Click OK and verify that the fields formatted show any entered number shows leading zeros up to eight digits.
=== Disable Green Triangle  ===
*Problem: How do I disable the green triangle in Excel telling me there are numbers formatted as text?
*Solution Here's how you can stop the green triangle from displaying in Excel (indicating that a number has been stored in text format):
**From the Tools menu, select Options.
**Click the Error Checking tab.
**Uncheck the box beside Number stored as text.
**Click OK.
== PowerPoint for Windows ==
=== PowerPoint not showing pictures or videos  ===
Symptom: You see the message "QuickTime and a &lt;codec name&gt; decompressor are needed to see this picture"
Solution: http://support.microsoft.com/kb/278556/en-us and http://support.microsoft.com/kb/198202/en-us
Symptom: QuickTime(TM) and a Photo - JPEG decompressor are needed to see this picture. QuickTime(TM) and a TIFF decompressor are needed to see this picture.
Solution: http://support.microsoft.com/default.aspx?scid=198204
Note: It is unclear if Office 2007 resolves this problem.
=== Cannot edit PowerPoint presentation  ===
'''Problem:''' You have a powerpoint file that you are unable to edit.
'''Solution:''' Check to make the sure has a .ppt file extension. If the file is a .pps (Powerpoint Show), it is uneditable. If you simply change the extension to .ppt it becomes an editable Powerpoint file.
=== Embed a Flash movie in PowerPoint ===
It is possible to embed a flash/shockwave movie/video/animation in PowerPoint, but it will work in the Windows version of PowerPoint ONLY. See:
*PowerPoint 2000 and 2003: http://office.microsoft.com/en-us/powerpoint/HA010348071033.aspx
*PowerPoint 2007: http://office.microsoft.com/en-us/powerpoint/HA012303211033.aspx
=== See also ===
* [[Play a sound file over multiple slides in PowerPoint]] - In Powerpoint, you can specify when a sound file should stop playing. For whatever reason Microsoft considers this a "Custom Animation" property.
* [http://office.microsoft.com/en-us/powerpoint/HP011474521033.aspx How do I create a template for my Power Point presentation]
* [[Video inserted in PowerPoint not playing smoothly]] - There can be a number of reasons for videos in powerpoint not playing smoothly, ranging from quality of video, to computer speed, and software version.
== Outlook (Windows) ==
=== Exchange Server not Found  ===
There are times, you log onto a computer connected by a wired connection and all that, fire up outlook and after a long wait you get an error message saying that the exchange server cannot be found and it gives you the option to retry or cancel. When it is almost certain that the connection to the network if OK, computer is registered and all that, the problem might be a bad profile. I don't know why it happens, how it happens but I know one possible fix.
*Click on Start -&gt; settings -&gt; control panel -&gt; mail
*Select profiles and remove all that are present
*Close everything and then set up Outlook
=== How to Share a Distribution List with Outlook ===
At times you may want to take an entire distribution list and share that list with others. Outlook allows you to do this by sending the entire distribution list as an attachment. The details are described in the [[Share a Distribution List using Outlook]] article.
=== Recovering Deleted Appointments in a Shared Calendar in Outlook  ===
When a user deletes mails from his/her personal mailbox or from a shared office mailbox, the mails will be stored in his/her personal "Trash" folder. The user must log into Outlook, find the mails in Trash, and drag them back into the Inbox or appropriate other folder.
More detailed steps: [[Recovering Deleted Items in Outlook]]
=== Outlook Running Very Slowly  ===
Common complaints about Outlook responsiveness are:
*It takes several seconds for a message to open.
*It takes several seconds for a message to disappear once I click Send.
When word is selected as the default e-mail editor - replying and sending is slower. When there are addins installed for Outlook (such as Google Desktop, Plaxo, etc.) opening messages is slow.
Possible solutions:
*Remove Outlook Add-ons: [[Remove Outlook Add-ins]]
*Uninstall Google Desktop
*Use Cached Exchange mode
*Follow the instructions here: [[Remove Word from being default e-mail editor]]
=== Error when printing daily Outlook calendar ===
Error: the messaging interface has returned an unknown error. If the problem persists, restart Outlook Happens when printing Outlook calendar in daily format.
Solution: This is a known issue. An option called "Task Pad" is turned on by default, and if there are no tasks for that calendar, and you try to print it, it creates that error. So the solution is to just turn off the task pad option.
Follow these steps to deselect the TaskPad option when printing the Daily Style: 1. Open the shared calendar 2. On the Outlook File menu, click Print. 3. Under Print Style, click to select Daily Style and click Page Setup 4. Click TaskPad to deselect it. 5. Click OK and OK to close and print.
=== See also ===
* [[Email configuration]] - General email configuration tips
* [[Inserting a signature in Outlook]]
* [http://www.middlebury.edu/academics/lis/help/helpdesk/documentation/email/outlook/set-up/ Configure Outlook for the Middlebury Exchange Server]
* [[Creating Outlook Templates]] for commonly sent messages
* [[Follow-up Flags in Outlook]] - The behavior of follow-up flags has changed in Outlook 2003 and 2007.
* [[Add Another Mailbox in Outlook]]
== Office for Mac ==
=== Install and configuration  ===
For instructions for installing and configuring Office 2008 for Mac, see [[Office_2008_Installation|Office_2008_Installation]]
=== Word  ===
=== Excel  ===
=== PowerPoint  ===
==== Insert More Than One Audio File in PowerPoint  ====
PowerPoint X and 2004: Insert =&gt; Sound from File. Can only do 1 sound file, but can have multiple sound files inserted as movie files (Insert =&gt; Movie from File) Have 1st sound file play automatically. PowerPoint 2008 has no limitations to the number of sound files inserted, so you don't need to insert the second sound file as movie.
Tutorial on how to adjust so the sound file plays continuously: http://www.royaltyfreemusic.com/tutorials/powerpoint.htm
=== Entourage  ===
==== Great resources for troubleshooting Entourage<br> ====
==== Viewing the members of a distribution list using Entourage<br>  ====
*[[Viewing the members of a distribution list using Entourage|Viewing the members of a distribution list using Entourage]]<br>
==== Dangerous Bug in Entourage 2004<br>  ====
*[http://www.middlebury.edu/academics/lis/help/helpdesk/documentation/email/entourage/entourage2004/entourage2004bug.htm Entourage 2004 Serious Bug - Lost Mailboxes and Setting the Exchange Server]<br>
==== Troubleshooting Entourage Speed Issues (slow, spinning beach ball, intermittent freezing)<br>  ====
*See [[Slow Entourage and Spinning Beachball|Troubleshooting Entourage Speed Issues]]<br>
==== Troubleshooting Calendar Issues in Entourage<br>  ====
*See [[Troubleshooting Calendar Issues in Entourage|Troubleshooting Calendar Issues in Entourage]]<br>
==== How do I delete attachments from email messages in Entourage? ====
*[[Delete attachments from email messages in Entourage]]
When you have a message open in Entourage you can decrease the font by:
*choosing Edit/Decrease Font Size
*pressing Shift+CMD+Minus sign (repeat as needed)
==== Entourage and Banner-generated e-mail messages  ====
It looked like earlier, Banner generated messages, separated e-mail addresses using commas "," and entourage thought that "jsmith, pclab, helpdesk" was one long e-mail address, so it didn't send the message to the email addresses. We checked now, and it looks like banner generated messages separate e-mail addresses using semi-colons ";". Now Entourage correctly understands that each entry is a separate email address. It should work fine that way. It does help to click the button titled "Check Names" -- if there is a problem this will generate a question mark, and if there is no problem, it will autocomplete all the email addresses, making sending quicker. To avoid having to click this button you can turn on Entourage =&gt; Preferences =&gt; Compose =&gt; "Automatically check names when sending messages".
In general, when entering e-mail addresses in Entourage's To, CC or BCC fields, each e-mail address needs to be on a separate line (enter one address, then click on the next line, enter the other address, click on the next line, etc...).
==== Entourage and sending messages to multiple recepients (To CC or BCC)  ====
See the section above.
==== Useful settings to enable in Entourage  ====
See [[Office 2008 Installation|Office_2008_Installation]]
==== Installing Entourage  ====
Entourage comes with the Microsoft Office installation cd, which can be obtained from the Main Library Circulation Desk. For installation notes see [[Office 2008 Installation|Office_2008_Installation]][[Office 2008 Installation|<br>]]
==== Adding Delegate and Other Mailboxes in Entourage  ====
See: [[Adding Another Mailbox in Entourage]]
[[Category:Applications and OS]]
[[Category:Helpdesk Documentation]]
[[Category:Public Search]]
[[Category:Microsoft Office]]
[[Category:Microsoft Office]]
[[Category:Specific applications]]

Latest revision as of 15:53, 10 August 2022

Related link: How do I find my MS Office Version?

Information Technology Services (ITS) began installing Microsoft Office 365 on computers provided during the staff upgrade process in spring 2019.

Installation Details

College-Owned Computers

Microsoft Office 365 is available for self service installation on both Mac and Windows college-owned computers.

Refer to the appropriate link below for installation instructions:

  • Windows: Install "Microsoft Office 365 ProPlus" via KACE Self Service.
  • Mac: Install "Microsoft Office 365 for Mac" via JAMF Pro's Self Service -- requires OS 10.12 (Sierra) or higher; OS upgrades are also available via the Self Service utility.

Personally-Owned Computers

Office 365 is available for installation on personally-owned computers. Visit Microsoft Office for Personal Computers for details.

How to Learn More about Office 365

Take a Short Course using LinkedIn Learning:


Use Microsoft's Resources
Powered by MediaWiki