Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 5th 08, 10:34 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 2
Default 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   Report Post  
Old November 7th 08, 05:05 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,276
Default 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   Report Post  
Old November 8th 08, 12:55 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
Default 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   Report Post  
Old November 10th 08, 01:21 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing:Data Connection Wizard Doesn't see Source Data - No Impo Exotic Hadron Excel Discussion (Misc queries) 0 October 1st 08 07:35 PM
Removing Data Tables formed from importing data from Access Andrea Jones Excel Discussion (Misc queries) 0 April 10th 08 12:01 PM
Importing Data: OLE DB and data link properties dialog Vivek Excel Discussion (Misc queries) 0 October 22nd 07 03:59 PM
Data types when importing Excel data to SQLServer [email protected] Excel Discussion (Misc queries) 1 September 27th 06 12:48 PM
Importing data, then adding data to the new spreadsheet.. a conund AndyL82 Excel Discussion (Misc queries) 1 March 9th 06 11:05 PM


All times are GMT +1. The time now is 05:05 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017