Hi Paul
You are correct, I don't want to break links. Not possible to send
workbook as it contains sensitive confidential information.
Just suppose there is a worksheet named A in workbook. It is linked to
external workbook named say X, Y and it is also linked to worksheets in
workbook say nam
It sounds like you're not wanting to REMOVE the links,but basically generate a
list of worksheets and the name of the external workbooks linked to those
sheets.
That doesn't sound difficult.
But the error you're suggesting doesn't make sense because you're not "pasting"
anything (with the macro
Hi Paul,
What I am looking for is below.
1. I have a workbook with 100 worksheets
2. Each worksheet is linked to several external Workbooks and several
tabs/worksheets within workbook.
3. What I want to do is first list all name of tabs sequentially in a new
workbook and against each worksheet na
Hi Paul,
What I am looking for is below.
1. I have a workbook with 100 worksheets
2. Each worksheet is linked to several external Workbooks and several table
within workbook.
3. What I want to do is first list all name of tabs sequentially in a new
workbook and against each worksheet name me
Hi Paul,
I am getting error message mentioning the cells cannot be pasted as the
size and shape is not same.
Regards,
Kaushik
On Tuesday, May 23, 2017 at 11:32:58 PM UTC+5:30, KAUSHIK SAVLA wrote:
>
> Hi Team,
>
> I am trying to do below in an excel. You can assume there are 60
> worksheets mi
What isn't working?What does your code look like?
I put random numbers in 100,000 cells in Book1.xlsbThen, in Book2, I put
100,000 cells with links to the corresponding cell in Book1.
I then created a macro module with:Option ExplicitSub RemoveLinks()
Dim aLinks, inx
aLinks = ActiveWorkbo