Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-05-2010, 07:37 AM
zleyphox zleyphox is offline Build link to an other excell doc Windows XP Build link to an other excell doc Office 2003
Novice
Build link to an other excell doc
 
Join Date: Jan 2010
Posts: 3
zleyphox is on a distinguished road
Default Build link to an other excell doc

Hi!
I've managed to link fileds to an other excell document.
IE. ='C:\[calc2009.xls]Page1'!A1
But now I'm trying to build a link so that it updates with a new year every time you change the year.
IE.


in B1 I write the year 2010.
Now the link in B2 changes to ='C:\[calc2010.xls]Page1'!A1

I've tried with ='C:\[calc&B1&.xls]Page1'!A1 and similiar, but with no success.

Is this possible?
Thanks for your help!
Reply With Quote
  #2  
Old 01-09-2010, 08:02 PM
zyzzyva57 zyzzyva57 is offline Build link to an other excell doc Windows 7 Build link to an other excell doc Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

Could you add more clarification?
Reply With Quote
  #3  
Old 01-17-2010, 09:47 AM
BjornS BjornS is offline Build link to an other excell doc Windows Vista Build link to an other excell doc Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi,
the text elements at the beginning at the end must be surrounded by the "-sign (shift-2).

In your case:
="'C:\[calc"&B1&".xls]Page1'!A1"

I tried it out and that should work for you I hope!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Build link to an other excell doc How to disable warning message in Excell astra Excel 1 11-07-2009 04:52 AM
formula in excell curlymal Excel 2 02-09-2007 11:34 AM
Build link to an other excell doc Excell stopped working TomC Excel 4 05-26-2006 11:40 PM
power point excell dshar PowerPoint 0 03-09-2006 04:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft