atw: Re: Merging Excel workbooks

2003 allows you to import Excel workfiles.

________________________________

From: austechwriter-bounce@xxxxxxxxxxxxx
[mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of MATILDA REICH
Sent: Thursday, 12 April 2007 4:02 PM
To: austechwriter@xxxxxxxxxxxxx
Subject: atw: Re: Merging Excel workbooks


Thanks Kubbua,
 
Tried it but only allows Text files.
Michelle, think you are right - copy/paste appears to be only option.
 
thanks.

>>> kubbua@xxxxxxxxx 12/04/07 4:22 pm >>>

Matilda,

Have you tried the import external data in the data
menu?


--- "Hallett, Michelle"
<Michelle.Hallett@xxxxxxxxxxxxx> wrote:

> Copy and paste?
>  
> Michelle
> 
> ________________________________
> 
> From: austechwriter-bounce@xxxxxxxxxxxxx
> [mailto:austechwriter-bounce@xxxxxxxxxxxxx] On
> Behalf Of MATILDA REICH
> Sent: Thursday, 12 April 2007 3:54 PM
> To: austechwriter@xxxxxxxxxxxxx
> Subject: atw: Merging Excel workbooks
> 
> 
> Hello all,
> I have an Excel problem. Someone at work mistook me
> for an Excel guru.
> They want to merge 35 spreadsheets into one excel
> document.
> As a combined document the total rows would come to
> between 3,000-4,000
> - well within Excel's capacity. 
> Excel does not appear to have the Insert File option
> Word does which
> allows you to append files. 
> Searched the Help but could only find
> "Troubleshooting merging
> workbooks" which is no help.
>  
> regards,
> Matilda
>  
>  
>  
> 
>
-----------------------------------------------------------
> 
> Sydney Water - Winner of the 2006 Stockholm Industry
> Water Award
> 
>
-----------------------------------------------------------
> 
>  
> 
> NOTICE: This email is confidential. If you are not
> the nominated 
> 
> recipient, please immediately delete this email,
> destroy all copies, and
> 
> 
> inform the sender. Sydney Water Corporation (Sydney
> Water) 
> 
> prohibits the unauthorised copying or distribution
> of this email. This 
> 
> email does not necessarily express the views of
> Sydney Water. 
> 
> Sydney Water does not warrant nor guarantee that
> this email 
> 
> communication is free from errors, virus,
> interception or interference.
> 
>
-----------------------------------------------------------
> 
>  
> 
> 
> 
>
************************************************************************
*****
> This email, and any files transmitted with it, are
> confidential and intended for use by the addressee
> only. The confidential nature of the information
> contained in the email and/or file attachment is not
> waived, lost or destroyed if it is sent to other
> than the addressee. Use or dissemination of the
> information contained in the email and/or file
> attachment, by a recipient other than the addressee,
> may cause commercial damage to both/either the
> sender and/or addressee. If you are not the
> addressee of this email/file attachment contact the
> sender immediately and delete this email/file
> attachment. 
> 
> All email communications to and from this company
> are filtered and stored for risk management purposes
> in accordance with our Computer and Email Policies.
> Please contact our Privacy Manager on (02) 8668 6947
> if you would like further information about our
> Policies in regard to these issues.
> 
>
************************************************************************
*****
> 
> 



       
________________________________________________________________________
____________
Food fight? Enjoy some healthy debate 
in the Yahoo! Answers Food & Drink Q&A.
http://answers.yahoo.com/dir/?link=list&sid=396545367
**************************************************
To post a message to austechwriter, send the message to
austechwriter@xxxxxxxxxxxxxx

To subscribe to austechwriter, send a message to
austechwriter-request@xxxxxxxxxxxxx with "subscribe" in the Subject
field.

To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx
with "unsubscribe" in the Subject field.

To search the austechwriter archives, go to
www.freelists.org/archives/austechwriter

To contact the list administrator, send a message to
austechwriter-admins@xxxxxxxxxxxxx
**************************************************

-----------------------------------------------------------
This message has been scanned by MailSweeper.
-----------------------------------------------------------

Other related posts: