Explore Office on Experts Exchange

Expert Solutions for Your Tech Problems

OfficeMicrosoft Office

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a nu...

Read more
  • 79K Content
  • 14K Contributors

Expert Spotlight
Finance Analyst

30 years in Financial Services and Management Accounting. CIMA trained but prefer the technical or system aspects of accounting.

Article

Another Conditional Formatting Trick In Excel

Have you ever wanted to make your MS Excel spreadsheet more easy to follow? Here is one way to do just that.
Article

Some database design ideas

I am not a database expert nor am I conversant with database design, but I have had a couple of run-ins with databases that are either badly designed or use a platform that doesn’t meet the needs of the end-user. I would like to think this is a "lessons-learned" synopsis.
Article
HD Blue Clouds

How to Troubleshoot OneDrive for Business When You Encounter Cloud Storage Sync & Upload Errors

This article showcases how to fix basic cloud storage and sync errors in OneDrive for Business on primarily Windows OS workstations, but some of the tips and troubleshooting steps could be easily applied to OneDrive - Personal usage (non-work related accounts) and Mac OS X workstations.
Article
Windows Laptop By Window With Outlook Pinned  -  Plant & Window

How to Troubleshoot Outlook When It Repeatedly Asks For a Password or Windows Security Field Entries

This article covers how to resolve Outlook password issues and serves as a guide when you keep entering credentials Outlook fails to remember. A "Needs Password" message is typically seen at the bottom of Outlook, or a Windows Security prompt keeps popping up over the Desktop version continuously.
Article
Troubleshoot & Fix Microsoft Outlook Problems

Troubleshoot and Fix Outlook Problems

1
Over the past few months, many folks seem to be having a variety of Outlook problems. This article contains troubleshooting and repair steps that will often solve the various issues people have been encountering. Step-by-Step instructions and illustrations included.
Article
Prevent and Restore Lost Outlook Contacts

Prevent Losing Contacts in Outlook

4
While repairing a troublesome IMAP connection with Office 365, a list of over 500 Outlook Contacts mysteriously disappeared. Learn how to prevent and safeguard yourself against that happening to you by following the steps in this article.
Article
Save and Restore your Recent Documents Lists

Backup and Restore "Recent Documents" entries in Microsoft Office Apps

5
Depending on the things you do with Microsoft Office, you can sometimes inadvertently lose your recent document lists in apps such as Microsoft Word and Excel. This article shows you how to back up and restore those lists when necessary. Enjoy...
Article
How to Swap 32-bit to 64-bit to 32-bit versions without losing Data

Swap Microsoft Office 365 from 64-bit to 32-bit or Vice Versa

6
The version of Microsoft 365 you have installed may not be ideal. This article explains how to change from a 32-bit install to a 64-bit install or vice versa. Snapshots are included for every step so very easy to follow. Works regardless if you use POP or IMAP accounts in Outlook. Enjoy...
Article

Creating a customized Access ribbon and Network Database

I wrote this article because I was unable to find an article on this here on EE. Read on for step-by-step instructions on how to create a custom command ribbon in your office applications that not only make them look more professional but also protects against the ID10T error.
Article

Callback functions in Microsoft Access VBA. Part 3

Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. This article covers how to share one callback function between multiple controls.
Article

Callback functions in Microsoft Access VBA. Part 2

Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. This article covers how to reconfigure a callback function.
Article

Callback functions in Microsoft Access VBA. Part 1

1
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. To get started, learn the basics.
Article

How to Migrate Public Folder Calendar to Office 365?

Public Folders in Exchange Server - Amazingly flexible and a lot more than just emails.
Article

Revitalise colours in the VB editor

The colour setting for coding in the VB editor (VBE) of Microsoft Office is a left-over from a past century. Here is how - with a few steps - to bring new life to the ancient editor.
Article

Indian number formatting of Currency in Microsoft Access and Excel

The Indian number format for currency has groups of two and three digits. The native Format function of VBA cannot handle this if Windows is set for a Western localisation. Thus, a custom method must be applied. Here it will be shown how to use dynamic formatting to accomplish this.
Article

Handle Archive Files and Folders With VBA the Windows Explorer Way

Windows Explorer lets you open archive (tar and tgz) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating archive files takes a little more - and that you'll find here.
Article
Text list in Excel

How to generate a list of sample text using Excel

Do you ever need to generate a column of sample text? Do it in Excel pretty quickly.
Article

Distribute Hours Evenly Between Two Dates

Recently I have answered a question on how to distribute hours evenly between two dates. I thought this isn't that difficult to do that in Excel with formula, but what I see from this question, it could be applied to other similar scenarios. So, let's try and see what could we do here.
Article

Add Security Protections for Data Extraction

The Get & Transform Data Wizard in Excel is a powerful tool. It allows the users to extract the data from the connected sources. But by delegating the privilege to users to access the connected sources, how could we ensure there is at least some degree of security is in place?
Article

Truly Random Numbers in VBA

6
Pseudo random numbers are right at hand in VBA. Obtaining truly random numbers, however, requires an external source. One is the Swiss Quantis QRNG Chip. The output from one of these has been made public by ETH Zürich, and here we present a complete solution for retrieval of random numbers in VBA.

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more