LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
D D is offline
external usenet poster
 
Posts: 121
Default Linked Cells

Hi:

I have a cell linked with another file in a different location;

ex: currentfile!E4=G:\\fileA!BSheet!E5+fileA!Bheet!E6

I would like to remove the link with fileA, keep the formula, change it to
one of the sheets in my currentfile without renaming the sheet that I want to
have the new link; I do not have BSheet in my currentfile!

If you rename for example the sheet from my currentfile to BSheet is working!

Does it make sense?

Thanks,

Dan
 
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
Linked cells Caroline Excel Worksheet Functions 1 September 24th 07 07:50 PM
linked cells Penka Links and Linking in Excel 1 September 23rd 06 08:15 PM
Linked Cells Staying With Cells Once Linked Workbook Update. [email protected] Excel Worksheet Functions 0 June 6th 06 09:32 AM
Excel inserted 0's in cells linked to blank cells lburg801 Excel Discussion (Misc queries) 5 October 28th 05 11:32 PM
linked cells titoto Excel Discussion (Misc queries) 4 June 4th 05 04:54 AM


All times are GMT +1. The time now is 02:21 PM.

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

About Us

"It's about Microsoft Excel"