MS Excel 2003 SP2
I'm working with a shared workbook. None of the worksheets are protected nor
is the workbook. For some reason I can't insert an iamge on any of the
worksheets.
When I choose the Insert/Picture option from the tool bar all options after
that are grayed out.
Where else can I check for workbook sttings that would prevent this?
I hope I can get an answer to this question before our project is over. For
now i will need to figure out a work around!
Thanks,
BB
Have a look at the quot;Limitations of shared workbooksquot; in the helpfile. You
will find that :
quot;In a shared workbook, you cannot do the following:
Insert or change charts, pictures, objects, or hyperlinks.quot;
So the answer would be, unshare the workbook, make your modifications then
re-share it again.
quot;Bugsquot; wrote:
gt; MS Excel 2003 SP2
gt;
gt; I'm working with a shared workbook. None of the worksheets are protected nor
gt; is the workbook. For some reason I can't insert an iamge on any of the
gt; worksheets.
gt;
gt; When I choose the Insert/Picture option from the tool bar all options after
gt; that are grayed out.
gt;
gt; Where else can I check for workbook sttings that would prevent this?
gt;
gt; I hope I can get an answer to this question before our project is over. For
gt; now i will need to figure out a work around!
gt;
gt; Thanks,
gt; BB
Thanks bigwheel that did the trick!
bb
quot;bigwheelquot; wrote:
gt; Have a look at the quot;Limitations of shared workbooksquot; in the helpfile. You
gt; will find that :
gt;
gt; quot;In a shared workbook, you cannot do the following:
gt;
gt; Insert or change charts, pictures, objects, or hyperlinks.quot;
gt;
gt; So the answer would be, unshare the workbook, make your modifications then
gt; re-share it again.
gt;
gt; quot;Bugsquot; wrote:
gt;
gt; gt; MS Excel 2003 SP2
gt; gt;
gt; gt; I'm working with a shared workbook. None of the worksheets are protected nor
gt; gt; is the workbook. For some reason I can't insert an iamge on any of the
gt; gt; worksheets.
gt; gt;
gt; gt; When I choose the Insert/Picture option from the tool bar all options after
gt; gt; that are grayed out.
gt; gt;
gt; gt; Where else can I check for workbook sttings that would prevent this?
gt; gt;
gt; gt; I hope I can get an answer to this question before our project is over. For
gt; gt; now i will need to figure out a work around!
gt; gt;
gt; gt; Thanks,
gt; gt; BB
You're welcome and thanks for the feedback
quot;Bugsquot; wrote:
gt; Thanks bigwheel that did the trick!
gt; bb
gt;
gt; quot;bigwheelquot; wrote:
gt;
gt; gt; Have a look at the quot;Limitations of shared workbooksquot; in the helpfile. You
gt; gt; will find that :
gt; gt;
gt; gt; quot;In a shared workbook, you cannot do the following:
gt; gt;
gt; gt; Insert or change charts, pictures, objects, or hyperlinks.quot;
gt; gt;
gt; gt; So the answer would be, unshare the workbook, make your modifications then
gt; gt; re-share it again.
gt; gt;
gt; gt; quot;Bugsquot; wrote:
gt; gt;
gt; gt; gt; MS Excel 2003 SP2
gt; gt; gt;
gt; gt; gt; I'm working with a shared workbook. None of the worksheets are protected nor
gt; gt; gt; is the workbook. For some reason I can't insert an iamge on any of the
gt; gt; gt; worksheets.
gt; gt; gt;
gt; gt; gt; When I choose the Insert/Picture option from the tool bar all options after
gt; gt; gt; that are grayed out.
gt; gt; gt;
gt; gt; gt; Where else can I check for workbook sttings that would prevent this?
gt; gt; gt;
gt; gt; gt; I hope I can get an answer to this question before our project is over. For
gt; gt; gt; now i will need to figure out a work around!
gt; gt; gt;
gt; gt; gt; Thanks,
gt; gt; gt; BB
- Oct 22 Sun 2006 20:10
Why would excel tool bar options be grayed out?
close
全站熱搜
留言列表
發表留言