Hi, In order to import Excel data into Prism, you cannot mix data types. What I would do is change the value Red to -9999 (for example). If you want this value to appear as Red in a pivot, you can rename it directly in the pivot by double clicking the -9999 member. We will be addressing this inconvenience...