ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing data into Excel (https://www.excelbanter.com/excel-discussion-misc-queries/191027-importing-data-into-excel.html)

mwy

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


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com