Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SPSS QUeries in Excel and refresh data
we have an excel query that we are linking to a Showcase SPSS database, and
we have a prompt to enter a certain type of data, and we first run it and we get 80 rows, then we re-run and the results are only 20 rows, but it doesnt clear out the other 60 rows from the first refresh. Is there a setting in excel to clear out the data (I know i have run across this before but it just seems to escape my mind right now!) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SPSS DATA FILE | Excel Worksheet Functions | |||
How do I import data from SPSS to excel? | Excel Discussion (Misc queries) | |||
Data Refresh Issues when linking Access queries to Excel | Excel Discussion (Misc queries) | |||
I cannot refresh all of the queries in my spreadsheet | Excel Discussion (Misc queries) | |||
Refresh queries, graphs, and charts | Excel Discussion (Misc queries) |