Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Importing data
Hello,
I have a workbook in Excel 2003 that I need some advice on please. The data used in the spreadsheet is collected online into a CSV file, this CSV file is imported into Excel onto a "Raw Data" worksheet. From this raw data several other worksheets need to access this raw data to prepare the reports required. I have the first report sheet designed and it picks up the data from the Raw Data sheet. The problem I need help with is updating the raw data; when I download a new file from our web site and refresh the data import the report worksheet does not update correctly. For example supposed there are three more rows of data in the Raw Data sheet, the report sheet does not show any extra rows. The report sheet is set up with many more rows that can be in the raw data so the formulas are there but the data does not appear. Here is a typical formula from the report sheet - =IF('Raw Data'!M21="","",'Raw Data'!M21) Any help would be much appreciated. Sid. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Importing data
Hi Sid,
Is working for me, try this, go the the Raw data worksheet and do Text to Columns for the columns you want to capture in the other worksheet "Sid Price" wrote: Hello, I have a workbook in Excel 2003 that I need some advice on please. The data used in the spreadsheet is collected online into a CSV file, this CSV file is imported into Excel onto a "Raw Data" worksheet. From this raw data several other worksheets need to access this raw data to prepare the reports required. I have the first report sheet designed and it picks up the data from the Raw Data sheet. The problem I need help with is updating the raw data; when I download a new file from our web site and refresh the data import the report worksheet does not update correctly. For example supposed there are three more rows of data in the Raw Data sheet, the report sheet does not show any extra rows. The report sheet is set up with many more rows that can be in the raw data so the formulas are there but the data does not appear. Here is a typical formula from the report sheet - =IF('Raw Data'!M21="","",'Raw Data'!M21) Any help would be much appreciated. Sid. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Importing data
Hi,
Should work, just make sure your spreadsheet is set to Automatic Recalculation or press the F9 key. -- Thanks, Shane Devenshire "Sid Price" wrote: Hello, I have a workbook in Excel 2003 that I need some advice on please. The data used in the spreadsheet is collected online into a CSV file, this CSV file is imported into Excel onto a "Raw Data" worksheet. From this raw data several other worksheets need to access this raw data to prepare the reports required. I have the first report sheet designed and it picks up the data from the Raw Data sheet. The problem I need help with is updating the raw data; when I download a new file from our web site and refresh the data import the report worksheet does not update correctly. For example supposed there are three more rows of data in the Raw Data sheet, the report sheet does not show any extra rows. The report sheet is set up with many more rows that can be in the raw data so the formulas are there but the data does not appear. Here is a typical formula from the report sheet - =IF('Raw Data'!M21="","",'Raw Data'!M21) Any help would be much appreciated. Sid. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Importing data
"ShaneDevenshire" wrote in
message ... Hi, Should work, just make sure your spreadsheet is set to Automatic Recalculation or press the F9 key. -- Thanks, Shane Devenshire Thank you for the two responses to my question. It appears the problem was due to the Data Range Properties not being set correctly. Once I changed these to "Overwrite existing cells with new data, clear unused cells" the second worksheet refreshes correctly when the data refresh is done. Sid. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing:Data Connection Wizard Doesn't see Source Data - No Impo | Excel Discussion (Misc queries) | |||
Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
Importing Data: OLE DB and data link properties dialog | Excel Discussion (Misc queries) | |||
Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
Importing data, then adding data to the new spreadsheet.. a conund | Excel Discussion (Misc queries) |