Office

»»Office

Some Files Can Contain Viruses or Harm Your Computer on SharePoint & OneDrive with Office

When opening, creating or saving an Office document, spreadsheet or presentation on SharePoint Document Library or Microsoft OneDrive (can be part of Office 365 service) with Microsoft Office applications such as Word, Excel or PowerPoint , the [...]

Suppress & Hide Formula Cell Value Error in Excel

When using many formulas in the workbook of Microsoft Excel, the spreadsheet may display error for formulas that do not return proper values or results. For example, the cell displays #N/A for value not available error, #DIV/0! [...]

By |2017-01-20T00:57:40+00:00January 20th, 2017|Categories: Office|Tags: |0 Comments

Sum the Total of Same Cell on All Worksheets in Excel

In Microsoft Excel spreadsheet software, there may be a need to sum the total of a cell in all individual worksheets to display in a master sheet. For example, you have 12 worksheets that contain sales figure [...]

By |2016-12-10T21:41:07+00:00December 10th, 2016|Categories: Office|Tags: , |0 Comments

Delete a Defined Name & Named Range in Excel

Microsoft Excel is the powerful and advanced spreadsheet application which comes as part of Microsoft Office. EXcel allows users to define name for individual cell, cell range, function, constant or table in order to be used in [...]

By |2016-12-09T08:38:16+00:00December 9th, 2016|Categories: Office|Tags: , |0 Comments

Microsoft Outlook Not Update Nor Sync Exchange Mailboxes / Inbox

When using Microsoft Outlook client to access Exchange mailboxes and Inbox, the Outlook does not actually update the all mailboxes and Inbox folder. The content and emails in the mailboxes are not refreshed, i.e. only the old [...]

By |2016-12-09T08:38:22+00:00December 9th, 2016|Categories: Office|Tags: |0 Comments

Outlook 2013 / 2016 IMAP Not Delete Emails in Gmail Inbox / All Mails

When deleting email messages in Microsoft Office Outlook 2013 or Outlook 2016 from Gmail (inclusive of both personal Gmail, paid commercial or free Google Apps) account which is configured to sync via IMAP protocol, the deleted emails [...]

Change Sync Folder Location of OneDrive for Business

OneDrive for Business is part of Office 365 or SharePoint Server which provides cloud storage and personal library for storing and organizing the work documents. By default, in Windows, when you sync a document library with OneDrive [...]

By |2016-12-09T08:38:29+00:00December 9th, 2016|Categories: Office|Tags: , , , |0 Comments

Open & Save Files in Google Drive from Microsoft Office Easily

If you are using Google Drive (either free personal account or as part of Google Apps), and are using the full-featured Microsoft Office desktop software such as Word, Excel and PowerPoint to create and edit your documents, [...]

By |2016-12-09T08:38:31+00:00December 9th, 2016|Categories: Office|Tags: , |0 Comments

Microsoft Office 2016 (Word, Excel, PowerPoint, Outlook, OneNote) Quick Start Guides

Microsoft Office 2016 was officially released by Microsoft on mid 2015. Office 2016 generally retains the similar yet simpler and improved user interface when comparing with its predecessor, yet it comes with various interesting new features, functionality [...]

By |2016-12-09T08:38:31+00:00December 9th, 2016|Categories: Office|Tags: |0 Comments

Microsoft Outlook Must Be Closed Because an Error Occurred on Mac

When opening Outlook for Mac 2011 or Outlook for Mac 2016 from Office for Mac productivity suite, the Outlook app displays the following error message within a few minutes of opening, and then the program crashes and [...]

By |2016-12-09T08:38:33+00:00December 9th, 2016|Categories: Office|Tags: , |0 Comments