LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
ChrisN
 
Posts: n/a
Default SumIF linked to another spreadsheet

I have a SumIf linked to another spreadsheet. It works if all spreadsheets
are open, but does not work if the source spreadsheets are not open. How can
I solve for this. I have linked this way before Excel 2003 - but this
version doesn't seem to allow it.
 
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
Help on creating a linked workbook. MT1 Excel Worksheet Functions 2 October 6th 05 02:15 PM
SumIf - Linked Workbook - #VALUE Lynn Excel Worksheet Functions 1 October 5th 05 09:54 PM
Loading a linked spreadsheet, Microsoft Visual Basic, error while. Wacher Excel Discussion (Misc queries) 0 April 18th 05 03:15 PM
Heavily linked spreadsheet freezes with "calculating cells 0%" - . MJGOBLUE Excel Worksheet Functions 1 April 10th 05 03:05 AM
Some exported records do not show on spreadsheet vulcan88 Excel Worksheet Functions 0 March 30th 05 01:11 AM


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