Importing data into Excel
I have set up a lot of imports from an AS400 file to Excel using Microsoft
Query. In 2003, these came through as unformatted data. Now, in 2007,
everything comes in as a chart. Manipulating data in the chart can be a paid
(such as cut and paste when you paste outside of the chart) and refreshing
the chart tends to realign linked formulas in a way that screws up everything
- can someone tell me how to change the format that the Microsoft Query comes
in as? Please help!
--
MY
|