Find a link

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

walshy - 06 Jul 2004 12:28 GMT

Hi wonder if you could help me... I have a file that when
I open it, it says not enough memory... This is due to a
link within the file somewhere...?

The problem is Ive searched every sheet (only 5) and I
cannot find the link anywhere... Ive looked on edit links,
and there is definatly a link there... but still as I said
searched every sheet even deleted all the sheets but the
link is still there ????? How is this possible...?

Ive been into VBEditor made sure there are no hidden
sheets... Also checked for any Macros... the only one
being on open worksheet.

'Private Sub Workbook_Open()

'Sheet3.EnableSelection = xlUnlockedCells

'End Sub

Please if someone could help me this would be great...?

Reply to this Message

Bill Manville - 06 Jul 2004 13:45 GMT

Walshy wrote:

> cannot find the link anywhere

Try FINDLINK.XLA from http://www.BMSLtd.ie/mvp

> not enough memory

Not usually caused by a link (though maybe it could be)
Is that the exact message?

"Not enough resources to display completely" is usually curable by
changing worksheet zoom factors to 100%.

"Not enough memory" usually means some internal memory area of Excel
has become full - maybe too many custom number formats or styles.

Which version of Excel?
Any idea what might have changed just before the problem started
happening?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message