Skip to main content
InSource KnowledgeCenter

030338 - AFWeb reports cannot copy and paste values

Problem

When copying data from a published report and then pasting into Excel, it also pastes the formulas, how can oyu get just the values?

Product Version: 9.2

OS: Win 2003

OS_SP: SP2

Solution

Do a paste special and choose to do the paste as Text. When this happens you will lose your formatting, but if you highlight the data and from the Data Menu choose Text to Columns and use Space as your delimeter it should help in restoring the columns back.

Close Date: 2009-10-30 16:50:56