Can't edit Excel document in browser with macros

Jan:

I've faced the same issue with an excel file that contains hyperlinks
to sheets within the same document and no macros.

The earlier suggestion (MS Kbase 162059) works but is unrealistic in
many situations depending on your I.T. restrictions (I.E. making a
script to edit the registry) or too much work for the end-user to
accomplish if they are Senior Executives that are non-technical.

The solution I use is as follows. I use one solution for files that I
am pushing out to a server in Europe; another for local servers in the
U.S. Either works

1) Zip the file and hyperlink to the zip file on your HTML page. When
the user clicks on the icon, they get another window where they can
click on the excel file. The file then opens as normal (via excel).

2) Hyperlink on your HTML page to an NT (or other) fileshare folder
example \\wv-fs-01\dashboard The user then clicks on the link, a new
windows explorer window opens up and they click on the excel icon. The
file then works as normal.

A third solution is to place instructions for the users to right-click
"save target as" and put the file on their desktop and then click it
from there. (Too many steps in my opinion).

I am unhappy with these solutions as they create one extra click for
users, but unfortunately Microsoft is not willing to address this
glaring flaw in their products.

In my case, the excel report is refreshed against live data nightly so
I wanted the least pain. It is used for Senior Execs and the file
loads with a main page with multiple hyperlinks to excel sheets in the
document and a 'return to main menu' hyperlink at the top of each page.
This allows one document to have 14 different standard 'slices' of
the information in a format that is not overwhelming to the user to
navigate. It also allows one portable document instead of multiple
links on an HTML page to different excel files. Finally, it avoids the
need to use any macros (thus avoiding any 'macro security warnings' if
the user's settingsa are set to 'high' in excel)


---
Message posted from http://www.ExcelForum.com/