Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-25-2012, 08:45 AM
TishyMouse TishyMouse is offline Referencing a named (calculated) range on a remote spreadsheet Windows XP Referencing a named (calculated) range on a remote spreadsheet Office 2007
Novice
Referencing a named (calculated) range on a remote spreadsheet
 
Join Date: Feb 2012
Posts: 22
TishyMouse is on a distinguished road
Default

Just to follow up on this, I have found the following information elsewhere (thanks 'Barry'!) and intend to try out the suggested solution:

Quote:
Dynamic Named Ranges have to be "Calculated" hence the need for the workbook to be open. A workbook can only be calculated when open.

However, how can you get around this. There is a kluge way around it. What you need to do is when the target workbook is open that before it closes it puts the address of the named range into a cell as a fixed value.

You should then be able to reference that address and retrieve the value and use it to in place of the dynamic named range.
Reply With Quote
 

Tags
calculated, named range, reference



Similar Threads
Thread Thread Starter Forum Replies Last Post
Referencing a named (calculated) range on a remote spreadsheet Excel - move with tab through named range mjlaw Excel 4 03-26-2012 10:40 AM
Referencing a named (calculated) range on a remote spreadsheet Add _ based on a calculated colums stovaaa Excel 4 03-09-2012 08:32 AM
Referencing a named (calculated) range on a remote spreadsheet Named range drop-down jgelpi16 Excel 1 04-08-2011 03:08 PM
Referencing a named (calculated) range on a remote spreadsheet Calculated dates. Ziggy-R Word 10 09-28-2010 01:42 AM
Referencing a named (calculated) range on a remote spreadsheet PowerPoint Remote Control ggh77 PowerPoint 2 04-16-2010 03:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:34 AM.


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