LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danedel
 
Posts: n/a
Default Linking to a closed workbook

I'm having trouble linking to a closed workbook. I want to update information
from that book to another book and am certain I have entered the correct
formula, at least according to Excel's help section, yet I get error
messages. Here's the formula:

=(€˜S:\office\Maint. OT 2006[JAN 2006 OT FORM.xls]JAN OT Tracking Chart
2006!AA6)

I'm not computing anything, just referencing data from a single cell.
Anyone's help would be greatly appreciated. Thanks.


 
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
Linking to workbook MattShoreson Excel Worksheet Functions 2 July 28th 05 03:43 PM
Linking cells in a worksheet to other worksheets in a workbook Dave Excel Discussion (Misc queries) 4 June 24th 05 06:18 PM
linking workbook data sir lancelot Excel Worksheet Functions 0 March 10th 05 04:03 PM
Linking Workbooks Dede McEachern Excel Worksheet Functions 0 January 21st 05 08:27 PM
Linking Data between worksheets in a workbook Terry Excel Worksheet Functions 2 November 8th 04 01:04 PM


All times are GMT +1. The time now is 04:57 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"