Question: When importing Excel files, I get the error message "[Affected cell] is invalid or not formatted as date". What can I do?
Answer: You get this error message if one or more cells are not formatted correctly, e.g., when a date (such as a project's start date) is formatted as text. Usually this is caused by overwriting the cell format when pasting data from other sources to Excel.
Depending on how many cells are affected, solve the problem by:
Step 1: Open the Excel file.
Step 2: Correct the formatting of the affected cells. If you're unsure how a certain cell should be formatted, simply create a fresh Excel export of your Meisterplan data and compare the formatting.
Step 3a (Best option if only a few cells are affected): Apply the correct formatting to the affected cell values. To do this, choose the affected cells, switch to editing mode (by pressing F2 or by clicking into the editing field below the toolbar), and confirm by pressing Enter.
Step 3b (Best option if many cells are affected): Paste the data (that you want to paste into Excel) from other sources into a format-free text file (e.g., .txt) first, and then copy it from there into Excel. When pasting in Excel, choose the "Values" option.
Step 4: Import the Excel file into Meisterplan again.