When I paste or import data from Excel to Prism, nothing is pasted, or incorrect (or truncated) values are pasted.

Here are all the reasons we know about that result in nothing being pasted into Prism after you select and copy data from Excel. 

• If data are formatted as "accounting" in Excel, they may not paste into Prism Windows. "Accounting" formatting aligns decimal points in Excel, but somehow this confuses Prism. Change to Number formatting by selecting the values in Excel and use Format Cells. Or in Prism Windows, use Paste Special and choose to paste the older text clipboard format (rather than the newer xml format) that Excel created.
• If the data format in Excel is simple fractions or percentages or dates, Prism does not recognize the values and does not paste then into numeric fields (but does paste them as text into column or row titles).
• If the column width in Excel is too narrow, the numbers may appear as #### in Excel, and then not paste properly into Prism.
• When you paste into the first row, Prism looks at the contents of the first row you are pasting to decide if it should go into row 1 of the table (if numbers) or into the column titles row (if labels). If you paste transpose, then that first row, might become row titles.  When making this decision, Prism 5.01 (and later) can get confused if the numbers you copy use a comma as a decimal separator, but the Windows Regional Settings control panel is set to use a decimal point as the decimal separator. In this case, either change the control panel setting or use Paste special and tell Prism what the comma means (first tab of Paste Special dialog).
• If you format your data in Excel to show a thousands separator, Prism can get confused. When this option is checked in the Format Cells dialog, the number one hundred thousand will appear as "100,000" or "100 000", depending on how your regional settings are configured. Prism 5 usually figures this out ok. WIth Prism 4, you need to specify this in the first tab of the Paste Special dialog. Older versions of Prism may get confused. The solution is to select your data in Excel, choose Edit..Format cells, go to the Number tab, and uncheck 'Use thousand separator'.
• If you format your table in Prism to be a survival table or a contingency table, then only integers can be imported or pasted. Contingency tables can only contain nonnegative integers. The Y columns of survival tables can also contain only nonnegative integers.

Older versions

• Early releases of Prism 5 mac had problems with Excel 2008. Details.
• Prism 2, but not more recent versions, was also confused when your system was set to use commas as a decimal point. The digits before and those after the decimal point are pasted into two different columns (e.g., 9.59 becomes 9.00 and 0.59). If you don't want to upgrade Prism, reset your system to use periods as the decimal separator.
• Data copied from Excel 2004 (Mac) sometimes cannot be pasted into Prism. See this note from microsoft.
• Early releases of Prism 5 Mac sometimes crashed on pasting data from Excel with versions of OS X that didn't exist when those releases of Prsim 5 were released. Fixed in the last Prism 5 release, 5.0f.