#1   Report Post  
Posted to microsoft.public.excel.misc
Jan Jan is offline
external usenet poster
 
Posts: 159
Default linked files

I had a DSUM formula in Excel 2003 that summed data from one file based on
criteria within another file; DSUM([Sales.xls]Billings!$A$:$Z$,15,$A88:$A89).
This worked just fine in Excel 2003! Now that I am using Excel 2007 it is
not working...what am I doing wrong? I tried updating the links (even though
the source file is open at the same time), and updating the calculations,
however, the cell remains blank.....HELP
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
#REF in linked files mohavv Excel Discussion (Misc queries) 1 October 16th 07 02:21 PM
Linked Files Sina Excel Discussion (Misc queries) 0 December 25th 05 08:54 AM
Linked Files Sina Excel Discussion (Misc queries) 0 December 25th 05 08:52 AM
LInked Files BiJi Excel Discussion (Misc queries) 0 September 23rd 05 07:21 PM
linked files Charlie 5280 Excel Discussion (Misc queries) 1 March 9th 05 06:21 AM


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