Analyze w/ MS EXCEL error

  • Thread starter Thread starter Gillian
  • Start date Start date
G

Gillian

When I select "OFFICE LINKS" then "ANALYZE WITH MS EXCEL"
to view my report in Excel, an extra blank column will
appear for what is meant for one column/field. Each
row/record will appear in the first column and the extra
column remains blank.

EXAMPLE: of what should be shown in two columns:
|1st column| |2nd column|
|TOTAL PRICE| |PAID|
|$45.95| |yes|
|$55.95| |no|

EXAMPLE: of what is shown for one column:
|1st column| |2nd column|
|TOTAL PRICE| |EMPTY FIELD|
|$ 45.95| |empty record|

PLEASE LET ME KNOW IF ANYONE HAS ANY SUGGESTIONS>>THANKS!
Sincerely,
Gillian
 
Rather than using the report with "OFFICE LINKS"
then "ANALYZE WITH MS EXCEL", I usually find it easier to
view the data to be taken to Excel in q uery format, this
way you have more control over the data and less errors in
the transfer due to format and report design difficulties.
Hope this helps.
Fons
 
Back
Top