Excel 2007
 

I'm facing a serious problem in Excel. I've linked some pdf documents with an
excel worksheet. Inorder to open this file, it takes extra ordinary delay
(almost 6 minutes). I think some security options should be cleared but don't
know which one. please advise me in this regard.

Again another problem is that,

if I want to insert a row in between this linked cells, an error message is
coming as follows;

"To prevent possible loss of data, Excell cannto shift nonblank cells off of
the worksheet. Select another location in which to insert new cells, or
delete data from the end of your worksheet. If you do not have data in cells
that can be shifted off of the worksheet you can reset which cells Excell
considers nonmbank. To do this, press CTRL +End to locate the last nonblank
cell on the worksheet. Delete this cell and all cells between it and the last
row and column of your data then save." This is the error message.

I will be grateful to you, if you can give me a reply.

Thanking you