hi,
use ISERROR for any version
On Jan 11, 2011 7:41am, Dave Bonallack <davebonall...@hotmail.com> wrote:
Hi,
If you are using xl2007 or more, you can use the IFERROR function.
In your case, I think the syntax would go something like this:
=IFERROR(INDIRECT(A1&"D$65")*1,"Linked Workbook not open!")
But I don't have XL2007 here to check it.
Hope this helps.
Regards - Dave.
> Date: Mon, 10 Jan 2011 02:08:37 -0800
> Subject: $$Excel-Macros$$ Linking spreadsheets using INDIRECT
> From: johnharw...@arrakis.es
> To: excel-macros@googlegroups.com
>
> I have an Excel spreadsheet which compiles a summary report by linking
> to many
> spreadsheets, whose file names are computed according to the date,
> eg If Cell A1
> contains '[Data_2010_December]Inputs'! the link formula might be =
> +INDIRECT(A1&"D$65")*1
>
> That works fine provided that file Data_2010_December.xls is open; if
> it is not open the
> result is #REF!
>
> Is there a way of getting around this, so that the links are live and
> values are preserved?
>
> --
>
----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
