Help!

How do I get around the 255 char limit?

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Links RSS
Next:  Links in 2003  
Author Message
Dave H
External


Since: Jun 09, 2006
Posts: 1



PostPosted: Fri Jun 09, 2006 6:05 pm    Post subject: How do I get around the 255 char limit?
Archived from groups: microsoft>public>excel>links (more info?)

I am linking a master spreadsheet to numerous spreadsheets. I am
pulling in text back to the master spreadsheet. I know that excel has
a 255 character limit for linked cells. I noticed however that when I
initially establish the link I can pull in 700+ characters. I have
realized that you get all the characters when the source spreadsheet is
open. In my case opening that many large spreadsheets would probably
overload my computer. Is there a way to trick excel into getting all
this without opening all these files?


--
Dave H
Back to top
macropod
External


Since: Sep 27, 2005
Posts: 994



PostPosted: Sun Jun 11, 2006 10:19 pm    Post subject: Re: How do I get around the 255 char limit? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Dave,

If you open the workbook without allowing it to update the links, they'll
retain the same amount of displayed data as when they were last saved. This
may allow you to open just those source workbooks that have been updated
since the target workbook was last saved. If you then open and close the
updated source workbooks sequentially, that should keep the performance hit
to a minimum. To make life easier, all this is possible through code. For
example, MS provides sample code for opening linked workbooks at:
http://support.microsoft.com/kb/213647/en-us
For your purposes, you'd probably want to modify the MS code to test the
source workbook's date/time stamp before opening it and to it again before
moving on to the next one.

Cheers

--
macropod
[MVP - Microsoft Word]


"Dave H" wrote in message

>
> I am linking a master spreadsheet to numerous spreadsheets. I am
> pulling in text back to the master spreadsheet. I know that excel has
> a 255 character limit for linked cells. I noticed however that when I
> initially establish the link I can pull in 700+ characters. I have
> realized that you get all the characters when the source spreadsheet is
> open. In my case opening that many large spreadsheets would probably
> overload my computer. Is there a way to trick excel into getting all
> this without opening all these files?
>
>
> --
> Dave H
Back to top
Dave H
External


Since: Jun 12, 2006
Posts: 1



PostPosted: Tue Jun 13, 2006 1:35 am    Post subject: Re: How do I get around the 255 char limit? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I am using excel 2003 when I choose not to update excel drops the
characters over 255. Opening each spreadsheet and then closing them is
a great idea however in this case I have about 80 to 90 linked
spreadsheets and each one is suffiecently large that it takes 1 to 2
minutes to open each one. So to run a macro could easily take upto 2
to 3 hrs to run and I don't think my users would wait that long.
macropod Wrote:
> Hi Dave,
>
> If you open the workbook without allowing it to update the links,
> they'll
> retain the same amount of displayed data as when they were last saved.
> This
> may allow you to open just those source workbooks that have been
> updated
> since the target workbook was last saved. If you then open and close
> the
> updated source workbooks sequentially, that should keep the performance
> hit
> to a minimum. To make life easier, all this is possible through code.
> For
> example, MS provides sample code for opening linked workbooks at:
> http://support.microsoft.com/kb/213647/en-us
> For your purposes, you'd probably want to modify the MS code to test
> the
> source workbook's date/time stamp before opening it and to it again
> before
> moving on to the next one.
>
> Cheers
>
> --
> macropod
> [MVP - Microsoft Word]
>
>
> "Dave H" Dave.H.295e65@news.excelbanter.com wrote in message
>
>
> I am linking a master spreadsheet to numerous spreadsheets. I am
> pulling in text back to the master spreadsheet. I know that excel
> has
> a 255 character limit for linked cells. I noticed however that when
> I
> initially establish the link I can pull in 700+ characters. I have
> realized that you get all the characters when the source spreadsheet
> is
> open. In my case opening that many large spreadsheets would probably
> overload my computer. Is there a way to trick excel into getting all
> this without opening all these files?
>
>
> --
> Dave H


--
Dave H
Back to top
macropod
External


Since: Sep 27, 2005
Posts: 994



PostPosted: Wed Jun 14, 2006 2:25 am    Post subject: Re: How do I get around the 255 char limit? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Dave,

I use Office 2000, which retains the full string unless the links are
updated. Shame it appears not to Work with O2003.

If you adopt the alternative approach I suggested, hopefully only a few
workbooks would need opening each time.

Yet another option would be to use a macro to retrieve the values from the
source workbooks without opening them. For information on how to go about
this, see: http://www.j-walk.com/ss/excel/tips/tip82.htm.

Cheers

--
macropod
[MVP - Microsoft Word]


"Dave H" wrote in message

>
> I am using excel 2003 when I choose not to update excel drops the
> characters over 255. Opening each spreadsheet and then closing them is
> a great idea however in this case I have about 80 to 90 linked
> spreadsheets and each one is suffiecently large that it takes 1 to 2
> minutes to open each one. So to run a macro could easily take upto 2
> to 3 hrs to run and I don't think my users would wait that long.
> macropod Wrote:
> > Hi Dave,
> >
> > If you open the workbook without allowing it to update the links,
> > they'll
> > retain the same amount of displayed data as when they were last saved.
> > This
> > may allow you to open just those source workbooks that have been
> > updated
> > since the target workbook was last saved. If you then open and close
> > the
> > updated source workbooks sequentially, that should keep the performance
> > hit
> > to a minimum. To make life easier, all this is possible through code.
> > For
> > example, MS provides sample code for opening linked workbooks at:
> > http://support.microsoft.com/kb/213647/en-us
> > For your purposes, you'd probably want to modify the MS code to test
> > the
> > source workbook's date/time stamp before opening it and to it again
> > before
> > moving on to the next one.
> >
> > Cheers
> >
> > --
> > macropod
> > [MVP - Microsoft Word]
> >
> >
> > "Dave H" Dave.H.295e65@news.excelbanter.com wrote in message
> >
> >
> > I am linking a master spreadsheet to numerous spreadsheets. I am
> > pulling in text back to the master spreadsheet. I know that excel
> > has
> > a 255 character limit for linked cells. I noticed however that when
> > I
> > initially establish the link I can pull in 700+ characters. I have
> > realized that you get all the characters when the source spreadsheet
> > is
> > open. In my case opening that many large spreadsheets would probably
> > overload my computer. Is there a way to trick excel into getting all
> > this without opening all these files?
> >
> >
> > --
> > Dave H
>
>
> --
> Dave H
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Links All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum