Jump to content
Wiley

Spreadsheet export

Recommended Posts

The only way that I've seen to produce a spreadsheet from TMG7.04 is with export. I've tried producing csv, tab, xls. In all cases I get 27 files that are some what useless when I bring them into Excel 2010. The only file that seems close ends with a '$' sign and it doesn't have all the data I need.

 

Any guidence would be appreciated

Share this post


Link to post
Share on other sites

You normally don't use export. Export exports raw data from the data tables.

 

You would normally generate a report (such as an appropriate List of... report) and select CSV or Excel as the report output format.

Share this post


Link to post
Share on other sites

You can produce spreadsheets from reports

Distribution of People

All the List of... reports with the EXCEPTION of List of Tasks

Share this post


Link to post
Share on other sites

ETA 10JUL2010: I figured out what my mental hangup was. I was stuck in MS Works 9 mode, which had been my output suite. I finally bit the bullet and got Office Home and Student 2010. But mentally I had not made the 'upgrade'.

 

Some days it just don't pay to get out of bed. For some reason I got hung up on 'export'. It never occured to me to generate a report and output to excel. Works like a charm. THANK YOU!

 

Before you lock/delete this thread please feel free to gather around and :bash: me.

Edited by Wiley

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×