Office 2007 Excel

[tobin5240]

Hi there,
I just recently got upgraded to excel 2007 version at work. On several
occassions I need to copy data from another system (for example peoplesoft)
and paste values the data into excel. The 2003 version would let me do this.
however, the 2007 version does not give me the option to paste values. As a
result, I am loosing formatting and formulas, and having to complete extra
steps to complete my reports. I have tried copying from peoplesoft and
pasting as text in excel 2007, but that does not allow any formulas to work
that were already in place. Any suggestions on what I can do?

 

[PA]

Try the following,
rather than pasting, start excel 2007, click the Data tab, and make the
appropriate choice in the External Data group.
I work with csv files a lot, into both Excel and Access 2007