Hai Friends

I have a problem in opening Excel files through shortcut. In order to
open i should open it through open - Standard tool bar in excel work
book.I had managed with this for last three days. But this has
agravating when i want to link values from one excel file to another
excel file as it is not recognising the another opend file. Even
inorder to move whole work sheet - after right click at sheet name -
sub menu - Move or copy( sub menu) fails to show already opened book
in to book tab.

Please help ..

Thanks
Hari.B

You need to untick the below setting in excel.

ToolsOptionGeneralIgnore other Applications.



Regards,
Shah Shailesh
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

*** Sent via Developersdex http://www.developersdex.com ***

Hi Hari

The behaviour you described occurs when you are trying to copy a sheet
from one instance of Excel to another.

I.e. it sounds as if the file you are working might load itself in a
new instance of excel hence you cannot see your already opened files
when you are trying to copy a sheet.

Proposed solution is to use hyperlinks to navigate between workbooks/
worksheets.

For copy sheet operations, maybe you can modify the workbook open
macro so that it doesn't open itself in a new instance of Excel,
assuming that the issue is the aforementioned on.

Regards

Law

On May 11, 1:44 pm, Hari wrote:
Hai Friends

I have a problem in opening Excel files through shortcut. In order to
open i should open it through open - Standard tool bar in excel work
book.I had managed with this for last three days. But this has
agravating when i want to link values from one excel file to another
excel file as it is not recognising the another opend file. Even
inorder to move whole work sheet - after right click at sheet name -
sub menu - Move or copy( sub menu) fails to show already opened book
in to book tab.

Please help ..

Thanks
Hari.B

Check your other post.

Hari wrote:

Hai Friends

I have a problem in opening Excel files through shortcut. In order to
open i should open it through open - Standard tool bar in excel work
book.I had managed with this for last three days. But this has
agravating when i want to link values from one excel file to another
excel file as it is not recognising the another opend file. Even
inorder to move whole work sheet - after right click at sheet name -
sub menu - Move or copy( sub menu) fails to show already opened book
in to book tab.

Please help ..

Thanks
Hari.B

--

Dave Peterson

Hi Hari

The behaviour you described occurs when you are trying to copy a sheet
from one instance of Excel to another.

I.e. it sounds as if the file you are working might load itself in a
new instance of excel hence you cannot see your already opened files
when you are trying to copy a sheet.

For manual copy sheet operations ensure that you open your files
within the same instance of Excel.

Regards

Law



On May 11, 2:13 pm, Shailesh Shah wrote:
You need to untick the below setting in excel.

ToolsOptionGeneralIgnore other Applications.

Regards,
Shah Shaileshhttp://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

*** Sent via Developersdexhttp://www.developersdex.com***

Hi Shah

Thanku very much
I got solution through ur suggestion
once again thanks a lot to all





On May 11, 5:13 pm, Shailesh Shah wrote:
You need to untick the below setting in excel.

ToolsOptionGeneralIgnore other Applications.

Regards,
Shah Shaileshhttp://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

*** Sent via Developersdexhttp://www.developersdex.com***