Excel Default Settings - (Ignore Other Applications)

There is a user in our office where her default excel settings is to ignore other applications

(Office 2003), You can find this under Tools -> Options -> General Tab.

There is a checkbox to ignore other applications. We want this OFF.

Every time she closes Excel, it defaults to on.

Does anyone know how to fix this?


Short version: Is there a registry setting for the "Ignore Other
Applications" setting?

Long version: Many people here have problems opening Excel files that are
remedied by:

1. Opening Excel, and clicking on 'Tools | Options... | General' tab.
2. Uncheck "Ignore Other Applications".

I also know this property can be set in Excel VBA:

Application.IgnoreRemoteRequests = False

However, there are a LOT of computers that seem to have this problem.

I figured that if this is being stored in a registry entry somewhere, I
can remotely connect to the user's registry, and set the value to false from
there, instead of having to run around to 100+ PC's, and repeat the processes
listed here.

Any ideas? Thanks!

After setting the "Ignore Other Applications" checkbox on the General tab of
Tools->Options, I get "Personal.xls locked for editing" when double-clicking
to open another spreadsheet. After clicking on the Read Only button of this
popup, the other spreadsheet correctly shows up.

After I close these workbooks out without saving I try to open again with a
double-click but get a popup which says it either can't find the spreadsheet
itself or one of its components and after clicking OK I get no workbook
showing at all.

If I then close this and just open excel with a blank workbook, uncheck the
"Ignore Other Applications" and close, all is well again.

It would appear then that "Ignore Other Applications" is persistent and
probably "stored" in personal.xls. But it might be nicer if this was
automatically unchecked when the last excel is closed.

Ken Shaffer

Windows 7 - Cannot run multiple instances of excel using "Ignore other applications that use DDE" option

To make it short and simple, I need to be able to have an excel workbook open in a new instance every time I double-click an excel file. As of right now, when multiple excel workbooks are opened, they all get dumped into the same excel instance. There seems to be no viable resolution to this for Windows 7 users.

With Windows XP, the option to display multiple excel 2007 instances at once could be achieved by checking the "Ignore other applications that use Dynamic Data Exchange (DDE)" checkbox. In Windows 7, when this option is checked, an error comes up stating "There was a problem sending the command to the program". I work at an accounting firm, so the ability to run multiple workbooks in different excel instances is absolutely crucial for daily workflow. Below are the steps I have attempted to get multiple excel instances running in Windows 7. If no one can offer a viable solution to this problem, I will be downgrading to Windows XP and will not deploy Windows 7 in our office until Microsoft acknowledges and resolves this issue.
I have ran excel 2007 in every compatible mode listed and tried switching the 'Run as Administrator' option off and on with each compatible mode. I attempted to edit the startup command for excel to the following:

I want to view my Excel workbooks in separate windows (I have 2
monitors and want different workbooks displayed in each). Looking
around online it seems the setting to allow this is:

Tools > Options > General > Ignore other applications

I selected this, and it works. When I click on an Excel file in
Explorer, a new instance of Excel opens.

However, when Excel opens, there is no workbook. I have to go to File >
Open and manually navigate to the file to edit it.

Is this a known side effect or some anomaly? Is there anyway to fix
this while still being able to open workbooks in separate windows?

Much appreciated...

Hello

How can i disable (or invisible) the checkbox "ignore other applications" in
Tools -> Options... -> General ?
I set this box to "true" from my excel application and nobody else should be
able to set it back to "false".

thanks for the help
s.wiederkehr

Hi

There are certain repetitive entries in another application that are
preformed on a daily basis. I understand there is a way that you can record
these basic macros in Excel and are able to perform or use them for other
applications.

Can anyone tell be how this is done or point me in the right direction to
find this information. It is basic entry and copy paste steps that I need to
record. I am about an intermediate user but if it is explained to me I could
probably figure it out.

I use exel 97 and also have 2003

I have used VBA to alter the user interface in Excel 2003. In the process
Excel crashed and has left remnants of the VBA generated interface. I wish
to get back to Excel default settings without having to reinstall Excel. I
have tried all the normal methods outlined in Excel 2003 help to no avail.

Thanks.

have default settings for new workbooks and worksheets including,
zoom=86/Arial 8/, 0.00/ etc. I set these up using the .xlt file for templates
and they work correctly. However, when I create a new window under the
"Window" menu item, it opens the new window with different (Excel Default?)
settings. Can this new window be made to open with my user-defined settings?

I have problem in Excel settings. I tried something in excel setting and its
saved.
Now problem is whenver open blank excel sheet it open with different setting.
Can you please tell me how to open the excel sheet in MS Excel default
settings.

regards
vishu

I'm trying to use Excel as an automation server form within my own
application, but I'm finding it very difficult to keep my own instance of
Excel isolated from the user's general Excel environment. I've found the
basic setting 'Ignore other Applications' (I forget the programmatic
property, and I don't have my code in front of me right now) which keeps my
copy of Excel isolated form any Workbooks / Excel instances that the user
may open from the windows shell. However this does have a rather nasty side
effect - it prevents workbooks from being opened by simply double-clicking
them from the windows shell. Presumably, by directing Excel to ignore DDE
requests (DDE - and this is 2006 :- ) it sets up Excel to ignore DDE
requests from the windows shell.

What the @$##$^% has Microsoft done here? How can Excel be taken seriously
as an automation server, if we can't create an isolated instance which
doesn't wack out and doesn't get wacked out by other instances of Excel??
This is Windows after all. The OS which is suppoed to support more than one
thing going on at any given time.

Thanks for any guidance which you can provide.

- Joe Geretz -

Hi everyone,

I need to send by e-mail automatically some print outs that shows me an application that I use in my job. This application has the option to launch any program wanted. The application needs the “exe” file and the complete path to launch other application, e. g.

C:program filesMicrosoft OfficeOffice12EXCEL.EXE

I have a macro that sends e-mails, but I need the execution of this macro automatically when my job application launches Excel.

1- It could be possible to put the macro like executable instead Excel.exe to launch it?
2- How can I run automatically the macro when Excel is launch it?

Thanks in advance

My client`s files will no longer open with
a double click

Things already tried.

Re associated the files to open with Excel
Opened the file/s directly from Excel
Made sur ignore other applications box is
cleared.
The next step will probably be to reinstall
Excel.
But before that does anyone have any other
things I might try?

Hi There,

I've created a Macro and placed it into the XLSSTART directory.
Everytime Excel is opened the Macro button appears. So far so good.
From within Navision we have an option that converts data to an Excel
sheet, this option starts Excel and fills the tables. Problem with this
is that when Excel is started from Navision, the Macro button doesn't
appear.

Consequently I'm thinking that Excel doesn't refer to the XLSSTART
directory when it 's started with an API-call from another
application?

Someone know how I can arrange things so that the Macro is available
even when Excel is launched via another application?

Cheers,
Kenneth

--
Vliegenmepper
------------------------------------------------------------------------
Vliegenmepper's Profile: http://www.excelforum.com/member.php...o&userid=27273
View this thread: http://www.excelforum.com/showthread...hreadid=467801

I have a user who is running Office 2007, and when she has an excel doc open,
then goes to Windows Explorer to look for other file(s), locates, and double
clicks on the new doc, the new doc opens, but the windows explorer window
remains on top. I have already gone in and ensured that the option in excel
to ignore is unchecked (Office Button, Excel Options, Advanced, Ignore other
applications that use Dynamic Data Exchange (DDE)). This didn't do anything
to help.

Any other suggestions so that the new excel document opens on the screen so
that the user can see it rather than the Windows Explorer window?

My coworker is having a hard time getting more than one workbook to open in a
single instance of Excel. It seems that no matter how we try to open the
second workbook, a new instance of Excel is opened.

"Ignore other applications" is not selected in Tools - Options.

For kicks I tried selecting that as an option and it made no difference.
Excel continued to open a new instance with every new file.

Any suggestions?

My coworker is having a hard time getting more than one workbook to open in a
single instance of Excel. It seems that no matter how we try to open the
second workbook, a new instance of Excel is opened.

"Ignore other applications" is not selected in Tools - Options.

For kicks I tried selecting that as an option and it made no difference.
Excel continued to open a new instance with every new file.

Any suggestions?

I have a user who is running Office 2007, and when she has an excel doc open,
then goes to Windows Explorer to look for other file(s), locates, and double
clicks on the new doc, the new doc opens, but the windows explorer window
remains on top. I have already gone in and ensured that the option in excel
to ignore is unchecked (Office Button, Excel Options, Advanced, Ignore other
applications that use Dynamic Data Exchange (DDE)). This didn't do anything
to help.

Any other suggestions so that the new excel document opens on the screen so
that the user can see it rather than the Windows Explorer window?

We've tried with no luck ...
1) Office Button > Excel Options > Advanced > General > Ignore other
applications
2) Start > Run > excel /unregserver > OK > Start > Run > excel /regserver

Any other suggestions???? Please help.

I need to know how to change a default setting. When I open a text file
(comma seperated) on my computer, I right click on it then choose "open with
Excel." The result is a fixed width, one column data block. When I try this
method on other machines, I get a poorly parsed mess because the default is
set differently. I have a collection of macros that I want to share with
other users in my office, but they can't use the macros because their data
does not have the same format. Since everyone is using the same software, it
seems that the default can be changed, but I can't find the setting and I
can't find any reference to it in the online help.

Hello,
I need help with microsoft excel 2010
When i paste large html code into an cell, all of the cell in the same column resize so big that i can hardly see. I was wondering how to stop the resize no matter how many characaters is in the cell by default setting. Same goes to when i enter numbers like 8783434393 it changes to 87+9.39833 by a default setting not every time thing. Lastly how to make each cell text appear only in that cell instead of flowing through other cell, as an default setting.

I know how to do 2 of th 3 problems in an manual way meaning doing it everytime when i face the problem, but i need to find out a default setting for this so it will stay like this forever.

I work for a company that is implementing a new chart of accounts to
manage our business. The new account length will be 12 characters in
length(e.g. 611500100001). Unfortunately, when this is entered in
Excel - Excel automatically changes the value to an exponent
(6.115E+11).
Now I know I can change the format to display the number correctly, but
actually want to either change the default exponent length setting or
worse case: remove the exponent feature altogether. One of the other
reasons that this will become a big problem is the fact that in my
company we utilize CSV (comma separated value) files extensively and we
modify it using Excel. Everytime a CSV file is opened all of the
accounts are changed to exponents.
Does anyone know of anyway to change excel's default setting for
switching a number to an exponent? If not, I'd even entertain the
thought of removing the exponent entirely from Excel as it will become
that big of a problem.
Thanks in advance for any feedback!

Rich S

Hi,

I hope someone could shed some light on this one! One of our users goes into tools, options and places a tick in 'Ignore other applications' under the general tab and removes the tick from 'move selection after enter' under the edit tab. The user then clicks on ok and closes down Excel.

Upon opening Excel next time round, they have noticed that these options which they have disabled/enabled are no longer effective. If we go back into options as above, the options which were selected/de-selected have gone back to what they were previously. It would appear as though Excel is not remembering these settings which have been selected by the user.

Even if I change these options on an existing Excel workbook, then save, close the workbook and then re-open, these options are not remembered. I have also tried to create a default Excel template, apply these options and then save the template to c:program filesmicrosoft officeoffice11xlstart but no difference to the issue.

The user would like these options to be remembered so that every time they open Excel, they do not have to re-apply the settings. I have tested this issue within Excel 2003 on numerous machines within our Network and the same problem happens.

Any ideas, any help would be greatly appreciated

Thanks

The Situation:
We graph data from data files in a Visual Basic 6 app by creating an Excel application object and having it generate the 2-D line chart. This application was developed about 6 years ago and the engineer who originally wrote it is long gone, so I have inherited it.

It has worked fine until we tried to use it on Excel 2007. We go with a lot of the default chart settings. When it was written, Excel 97 and Excel 2000 were current and it still works fine with Excel 2003. But now with Excel 2007, some of the default settings seem to have changed. For example, the chart title's default color has changed from black to white. I've solved that problem by explicitly setting the color to black, thus overriding the new default.

It's the other change that I can't get a handle on. The plot line itself used to be thin and black, but now it's thicker and blue. Blue isn't so much a problem, but we want to make it thin again so as to not hide the details.

The Visual Studio 6 help files provide no information on working with Excel objects. I have been using the Excel 2003 help files to see what objects are available, but when I try most of what it provides VB6 chokes on it. Here's the latest that I've been able to find and try:

    With wkbExcel.ActiveChart
      .ChartType = xlXYScatterLinesNoMarkers
      .SetSourceData Source:=wkbExcel.Worksheets(1).Range(strSourceData), _
                     PlotBy:=xlColumns
      GoSub AdjustProgress
      .Location Where:=xlLocationAsNewSheet
      .HasTitle = True
      .Shapes.SelectAll
      sr = Selection.ShapeRange
      sr.Line.ForeColor.RGB = RGB(255, 0, 0)
sr is Dim'd as ShapeRange, as per the help file. It chokes on the Selection.ShapeRange, which was also written precisely as per the help file.

BTW, it's just for test purposes that I'm trying to set the line to red, so that I can see whether the change I'm trying to make does actually appear. Of course I'll change it back to black once I'm there.

the default settings in autosave requires the user to reset the settings each time I open excel.
I would like to change this so that the once I set the autosave, say every
5 minutes and "do not prompt me for each save", this would be my default setting and it would take effect automatically when I open excel.
Can this be done?
Thank you
Benjisewell

I'm running into a lot of external link errors on two seperate workstations, but duplicating the same steps runs into link errors on one station, not both.

I'm concerned that the users have changed various settings personally within their Excel 2007, but I don't know enough about the new version to know where to look and what to change back (if indeed this is the root of the problem).

Is it possible to set the entire application back to the original defaults?