Problem - In opening Excel file through shortcut
 

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

Problem - In opening Excel file through shortcut
 

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 ***

Problem - In opening Excel file through shortcut
 

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

Problem - In opening Excel file through shortcut
 

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

Problem - In opening Excel file through shortcut
 

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***

Problem - In opening Excel file through shortcut
 

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***