View Single Post
  #4   Report Post  
Ken Wright
 
Posts: n/a
Default

Sorry my reply was to the text

I'm trying to convert quattro pro files into excel files.


For that kind of functionality you really need to look at either Pivot
Tables or the D functions, eg DSUM etc.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"raflknr" wrote in message
...
What function within excel is the same as the "notebook query" function

that
is in quattro?

"Ken Wright" wrote:

Believe you can save as a .wk4 file and then open directly in Excel

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------

--
It's easier to beg forgiveness than ask permission :-)


--------------------------------------------------------------------------

--

"raflknr" wrote in message
...
I'm trying to convert quattro pro files into excel files. In quattro

pro
I
can build a database just by making a table, then using the "notebook

query"
button. Is there a similar way to do the same thing in excel?