"Auto-open" on remote server

Tigerstyler

Board Regular
Joined
Mar 17, 2003
Messages
53
Hi,

I'm working on a restricted remote server, which effectively means I don't have a C:\drive, and I don't have access to any of the program files etc.

Whenever I open Excel, it just defaults to open a new Book1.

All of my setups/macros etc are stored on my personal workbook. Is there any way I can automatically open my personal workbook in this scenario?

Thanks!
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
not sure, but how about saving the personal.xls to somewhere you do have access to (keep it the only thing in that folder) & using it as the alternative startup location (tools | options | general)
 

Tigerstyler

Board Regular
Joined
Mar 17, 2003
Messages
53
Good idea Paddy thanks, not sure if it will work or not. I think that there are multiple users who appear to access the same version of Excel on this rubbish citrix server, so I'm wondering if other users will be getting my personal workbook open-up in other branches?!

I'll try it and see!
 

Tigerstyler

Board Regular
Joined
Mar 17, 2003
Messages
53
Well, I tried it, and neither thing happened.

The alternative location worked, but the settings are reset each time you log off the server!

I think I'm going to have to set up a shortcut directly to the personal.xls workbook and get users to open that instead of the normal excel.exe file.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,161
Messages
5,768,547
Members
425,481
Latest member
ihumanl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top