Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 30th 09, 02:09 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 3
Default Linking workbooks unpredictable

Have a strange issue. Sometimes I am unable to link two worksheets together.
In some cases when I enter either "+" or "=" in the cell and then click on
the cell in the other workbook that I want to link it does not work. I
thought the issue was related to the workbooks being in different directories
but when i moved them into the same directory it still did not work. Anyone
seen this issue? If so what was the fix.

  #2   Report Post  
Old May 30th 09, 03:00 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Linking workbooks unpredictable

I'm guessing that you have the two workbooks open in different instances of
excel.

Close one of the workbooks (and that instance of excel), then use File|Open in
the remaining instance to open that file once again.

Then try once more.

Johnathan wrote:

Have a strange issue. Sometimes I am unable to link two worksheets together.
In some cases when I enter either "+" or "=" in the cell and then click on
the cell in the other workbook that I want to link it does not work. I
thought the issue was related to the workbooks being in different directories
but when i moved them into the same directory it still did not work. Anyone
seen this issue? If so what was the fix.


--

Dave Peterson


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
hyperlink unpredictable merlin New Users to Excel 2 May 28th 09 12:59 AM
cell format unpredictable willy Excel Discussion (Misc queries) 5 November 12th 08 09:00 PM
Linking Workbooks crimlaw73 Excel Worksheet Functions 0 September 17th 08 08:43 PM
Linking Workbooks crimlaw73 Excel Discussion (Misc queries) 0 September 17th 08 08:42 PM
Subscript out of range ... sometimes! (Same code unpredictable re Dennis Excel Discussion (Misc queries) 3 August 11th 05 02:58 PM


All times are GMT +1. The time now is 01:22 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017