$$Excel-Macros$$ Break Internal Links with in a Workbook-Excel

Dear Excel Gurus, I have a workbook with multiple Tabs which are interlinked. I want to break all the link at once. Is it possible with any shortcut / key stroke or Tricks ? Please help me out. Thanks in advance. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R)

Re: $$Excel-Macros$$ Break Internal Links with in a Workbook-Excel

Hi You can use this code: Sub BreakLinks() Dim wb As Workbook Set wb = Application.ActiveWorkbook If Not IsEmpty(wb.LinkSources(xlExcelLinks)) Then For Each link In wb.LinkSources(xlExcelLinks) wb.BreakLink link, xlLinkTypeExcelLinks Next link End If End Sub On Fri, May 23, 2014 at 12:24 PM,

Re: $$Excel-Macros$$ Break Internal Links with in a Workbook-Excel

Hi Sandeep, If you are using 2010 and above, there is an option in excel, use this. Go to data option, you will see one option called EDIT LINKS, click this and there is one option to break links. On Fri, May 23, 2014 at 12:47 PM, Vaibhav Joshi v...@vabs.in wrote: Hi You can use this code:

$$Excel-Macros$$ Need Help

Dear Friends, Need your help in IF formula. I have attach the file for your input. Thanks Regards, *Imran Khan* *Lead Planner - OR/CSU* Ras Al-Khair Industrial City P.O. Box 11342, Jubail Industrial City - 31961, Saudi Arabia Mobile Phone: +966-555160349 Email : kha...@mac.maaden.com.sa

Re: $$Excel-Macros$$ Need Help

=IF(AND(C2=,D21),1,0) Drag down. HTH/Abhishek On Sat, May 24, 2014 at 1:04 AM, Imran Khan ikha...@gmail.com wrote: Dear Friends, Need your help in IF formula. I have attach the file for your input. Thanks Regards, *Imran Khan* *Lead Planner - OR/CSU* Ras Al-Khair Industrial City

$$Excel-Macros$$ Open office

Hi, Can we create macro in open office calc. I need to send file every hour using outlook. Regards CK -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM