Category Archives: Office

[Solved] Add, Attach or Insert A File in Excel 2013/2016 in 3 Easy Steps

By | November 16, 2016

This article will show you how to easily add/attach file like PDF, Word or any other to Excel 2013/2016 spreadsheet. Go to INSERT tab Click Object button or in case of smaller Excel 2013 window or any size Excel 2016 window: Click Create from file and browse for the file. Checking Link to file will cause file not… Read More »

Import iCalendar ICS or vCalendar VCS files to Outlook

By | August 2, 2016

Steps below will show how to import iCalendar (.ics) or vCalendar (.vcs) file into Outlook. Go to File tab Click Open & Export tab, next in main window click Import/Export button In Import and Export Wizard select Import an iCalendar (.ics) or vCalendar file (.vcs) option Now you can choose if you want to Import or Open as… Read More »

Solve: This value doesn’t match the data validation restrictions defined for this cell

By | June 10, 2016

When you try to input some value in a cell and you get an error message in Excel 2016: or in Excel 2013: This means that someone has set Data Validation on that cell. To view its configuration and remove if needed follow these steps: Select cell and go to Data -> Data Validation Depending on the size… Read More »

Why cell displays formula instead of results in Excel?

By | November 12, 2015

Below are the top 4 most common reasons why formula text is shown in cell instead of its results. They are sorted by frequency with most popular at the top. They apply to Excel 2013 and Excel 2016. No equal sign before the formula Make sure that there is an equal sign before the formula. Formula is inside… Read More »