Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

limited columns?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nickie - 28 Jul 2006 05:39 GMT
I am working with a large data set. (It is currently a form in Microsoft
Word)  I need to import data into Excel (2003) but am getting an error
message which does not allow me to import all of the data since I have
exceeded the range of columns available in my spreadsheet.  I thought that i
could get around this by importing the data vertically (into columns) as
opposed to horizontally (into rows) (ie : currently each row is a client, and
each column represents a question - I was hoping that I could import the data
whereas one client would be represented by a column)

Could anyone tell me how I can acheive this or perhaps give me another
suggestion?

I truly appreciate any help I can get!

Thanks
SteveW - 28 Jul 2006 09:21 GMT
How many Clients and how many questions do you have in the Word file

If both are over 256 - you will have to split into several sheets of  
upgrade to the latest Excel.

Steve

> I am working with a large data set. (It is currently a form in Microsoft
> Word)  I need to import data into Excel (2003) but am getting an error
[quoted text clipped - 14 lines]
>
> Thanks
Nickie - 29 Jul 2006 16:27 GMT
Thanks for the response Steve!  I have approximately 350 clients and 280
questions.  Is the only way to do it is to upgrade to another excel program -
if so, which one?

Thanks again for all of your help!

Nickie

> How many Clients and how many questions do you have in the Word file
>
[quoted text clipped - 21 lines]
> >
> > Thanks
SteveW - 29 Jul 2006 16:50 GMT
use the rows for Clients - they will increase, easier to manage

Questions - if you could break them up into groups
seperate sheet for each group - 200+ questions for each group.
As many (nearly) groups as you like

for me, even if you upgrade a more manageable way of handling the data.

Steve

> Thanks for the response Steve!  I have approximately 350 clients and 280
> questions.  Is the only way to do it is to upgrade to another excel  
[quoted text clipped - 33 lines]
>> >
>> > Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.