Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alexandre Duarte
 
Posts: n/a
Default Working with several worksheets

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default Working with several worksheets

Can you translate
Não consegue ler o ficheiro

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Alexandre Duarte" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.misc
Alexandre Duarte
 
Posts: n/a
Default Working with several worksheets

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" wrote in message
...
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




  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default Working with several worksheets

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" wrote in message
...
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" wrote in message
...
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






  #5   Report Post  
Posted to microsoft.public.excel.misc
Alexandre Duarte
 
Posts: n/a
Default Working with several worksheets

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" wrote in message
...
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" wrote in message
...
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








  #6   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default Working with several worksheets

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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








  #7   Report Post  
Posted to microsoft.public.excel.misc
Alexandre Duarte
 
Posts: n/a
Default Working with several worksheets

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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









  #8   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default Working with several worksheets

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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











  #9   Report Post  
Posted to microsoft.public.excel.misc
Alexandre Duarte
 
Posts: n/a
Default 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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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












  #10   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default Working with several worksheets

No problem



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Alexandre Duarte" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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














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
working with multiple worksheets Shaun Excel Discussion (Misc queries) 1 November 3rd 05 06:59 AM
Working with multiple worksheets Paul Excel Discussion (Misc queries) 1 November 3rd 05 03:03 AM
working with data between worksheets steve Excel Discussion (Misc queries) 1 August 10th 05 01:16 PM
slight variation when working with separate worksheets Mr. Snrub Excel Discussion (Misc queries) 2 May 19th 05 01:24 PM
Linking across worksheets not working as desired Steve Excel Worksheet Functions 0 April 27th 05 10:30 AM


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

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

About Us

"It's about Microsoft Excel"