Re: Working with several worksheets

Sorry, it's difficult because it's not mine and it contains sigilous info.


"Ron de Bruin" escreveu:

> Can you send me one of the workbooks private
> I try it also for then
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Alexandre Duarte" <AlexandreDuarte@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:D505A15B-C5D2-4972-8CC6-D9E35D6CDE2B@xxxxxxxxxxxxxxxx
> > Well, I have 1 workbook collecting data from 7 other ones.
> > I get the error when I open that one with the 7 others closed.
> > If I hit the OK button (seven times) on the message error box, everything
> > looks right.
> > If the 7 workbooks are open all goes right!!
> >
> >
> > "Ron de Bruin" escreveu:
> >
> >> I have no idea on this moment
> >>
> >> Is this only one workbook or more that have this problem
> >>
> >> --
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >> "Alexandre Duarte" <AlexandreDuarte@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:AA88658B-A202-410D-808F-79E80CA7D282@xxxxxxxxxxxxxxxx
> >> > Tanks Ron
> >> > Exactly. The only diference is that I've discard the '$' on the adresses.
> >> >
> >> > "Ron de Bruin" escreveu:
> >> >
> >> >> Hi Alexandre
> >> >>
> >> >> Do you use links in cells like this
> >> >>
> >> >> ='C:\Documents and Settings\Ron\My Documents\[Book2.xls]Sheet1'!$A$1
> >> >>
> >> >> --
> >> >> Regards Ron de Bruin
> >> >> http://www.rondebruin.nl
> >> >>
> >> >>
> >> >> "Alexandre Duarte" <AlexandreDuarte@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> >> news:8DB3641A-CC77-4A6F-B8E9-1C2886BCED32@xxxxxxxxxxxxxxxx
> >> >> > It's something like "Can't read the file" I guess ...
> >> >> >
> >> >> >
> >> >> > "Ron de Bruin" escreveu:
> >> >> >
> >> >> >> Can you translate
> >> >> >> Não consegue ler o ficheiro
> >> >> >>
> >> >> >> --
> >> >> >> Regards Ron de Bruin
> >> >> >> http://www.rondebruin.nl
> >> >> >>
> >> >> >>
> >> >> >> "Alexandre Duarte" <AlexandreDuarte@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> >> >> news:81966821-CD44-4E93-B55E-43273A6F0F48@xxxxxxxxxxxxxxxx
> >> >> >> > Hi
> >> >> >> > I received an error "Excel: Não consegue ler o ficheiro" when linking data
> >> >> >> > from several worksheets.
> >> >> >> > If those worksheets are open everything looks all right, but when they are
> >> >> >> > close ...
> >> >> >> > Someone can help me
> >> >> >> > Thanks
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
.