Hello all. I have installed Office 2003, and everytime that my users
make changes to anything in Excel, it gives them a message asking them
to save a copy or overwrite the file. There are too many files in
Excel for us to be going in to each one to run a macro and I have even
tried the Microsoft Registry fix and that seemed to work, until this
morning, it started right back. Any help on this subject matter would
be greatly appreciated. Thanks

ther are a couple of possibilities

1) The default directory that is set up is read only. You havve to chage
the default directory for excel.

2) the startup command may be selecting /r (see below)
You need to check in Windows explorer

Tools - Folder Options - file types
Select XLS and press Advance
Select Open -edit
Look at the end of the "Applicatio used to perform action".
cehck to see if there is a /r
My line only has /e


Customize how Excel starts
Show All
Hide All
Open a workbook automatically when Microsoft Excel starts

Use the XLStart folder

Any workbook, template (template: A workbook that you create and use as the
basis for other similar workbooks. You can create templates for workbooks and
worksheets. The default template for workbooks is called Book.xlt. The
default template for worksheets is called Sheet.xlt.), or workspace file
(workspace file: A file that saves display information about open workbooks,
so that you can later resume work with the same window sizes, print areas,
screen magnification, and display settings. A workspace file doesn't contain
the workbooks themselves.) you place in the XLStart folder is automatically
opened when you start Excel. This XLStart folder was created when you
installed Excel, and is located in one of the following places:
C:\Documents and Settings\username\Application Data\Microsoft\Excel
C:\Program Files\Microsoft Office\Office11
Use an alternate startup folder

To automatically open a workbook, template (template: A workbook that you
create and use as the basis for other similar workbooks. You can create
templates for workbooks and worksheets. The default template for workbooks is
called Book.xlt. The default template for worksheets is called Sheet.xlt.),
or workspace file (workspace file: A file that saves display information
about open workbooks, so that you can later resume work with the same window
sizes, print areas, screen magnification, and display settings. A workspace
file doesn't contain the workbooks themselves.) from a folder other than the
XLStart folder, you can specify an alternate startup folder (alternate
startup folder: A folder in addition to the XLStart folder that contains
workbooks or other files that you want to be opened automatically when you
start Excel and templates that you want to be available when you create new
workbooks.).
On the Tools menu, click Options.
On the General tab, in the At Startup, open all files in box, type the full
path of the folder you want to use as the alternate startup folder.
Caution Because Excel will attempt to open every file in the alternate
startup folder, make sure you specify an empty folder or a folder that
contains only files that Excel can open.

Note If a file with the same name is in both the XLStart folder and the
alternate startup folder, the file in the XLStart folder opens.

Use startup switches when you start Excel

On the Start menu, point to Programs, point to Accessories, and then click
Windows Explorer.
In Windows Explorer, go to \Program Files\Microsoft Office\Office11,
right-click EXCEL.exe, and click Create Shortcut.
Right-click the shortcut you created, click Properties, and then modify the
path in the Target box with switches from the following table.
Note Switches are not case sensitive: /O is the same as /o. In some
scenarios, you can use more than one switch at a time. If you use more than
one switch at a time, you must separate the switches with spaces. For
example: /o /s

To start Excel and Type
Prevent display of the Excel startup screen and a new blank workbook /e or
/embedded
Create a new workbook that contains a single macro sheet /m
Force Excel to re-register itself /o
Specify the working folder as the active working folder instead of the
default working folder /p workbook path
Open a specific workbook as read-only (read-only: A setting that allows a
file to be read or copied, but not changed or saved. If you change a
read-only file, you can save your changes only if you give the document a new
name.) /r workbook path\file name
Specify Office Safe Mode /s, /safe, or /safemode
Open and close Excel to rewrite all registry keys and reassociate Excel with
all Excel files, such as workbooks and charts /regserver
Open and close Excel to unregister Excel /unregserver

Click OK.
Move the shortcut to \Windows\Documents and Settings\Start Menu.
Note Your custom shortcut may be replaced by a Windows Installer shortcut
if you name the shortcut Microsoft Excel, and either of the following are
true:

You use the Detect and Repair command in Microsoft Office, and you selected
the Repair my shortcuts while repairing check box.
You select the Repair Office option in Maintenance Mode setup, click the
Repair errors in my Office installation option, and then select the Restore
My Shortcuts check box.
If a Windows Installer shortcut replaces your custom shortcut, you must
re-create your custom, non-Windows Installer, shortcuts.

Stop a workbook from loading when Excel starts

This procedure clears all ways in which a workbook could be loaded.

On the Tools menu, click Options, and then click the General tab.
Clear the contents of the At startup, open all files in box.
Remove workbooks stored in the XLStart folder.
In Windows Explorer, remove the icon of the workbook you want to open in an
alternate startup folder.
Remove a startup switch from the Excel icon.
Right-click the Excel icon that you want to use to open Excel, and clear the
contents of the Target box.
Start Excel without running automatic macros

Automatic macros, such as Auto_Open, are designed to run when you start
Excel. For more information about these macros, see Microsoft Visual Basic
Help.

To prevent macros from automatically running, hold down SHIFT while you
start Excel.
Note If you start Excel from the Office Shortcut Bar, click the Microsoft
Excel button on the Office Shortcut Bar first, and then immediately hold down
SHIFT while Excel starts.

Start Excel without the Startup task pane

On the Tools menu, click Options.
On the View tab, under Show, clear the Startup Task Pane check box.
Save workbook settings you want to use every time you start Excel with a
workbook template (book.xlt)





On the Excel tools -Option Menu
Select General.
Change Default file Location.

" wrote:

Hello all. I have installed Office 2003, and everytime that my users
make changes to anything in Excel, it gives them a message asking them
to save a copy or overwrite the file. There are too many files in
Excel for us to be going in to each one to run a macro and I have even
tried the Microsoft Registry fix and that seemed to work, until this
morning, it started right back. Any help on this subject matter would
be greatly appreciated. Thanks