VBA Excel

  Noldi 09:47 13 Oct 09
Locked

Since upgrading to Office 2007 I now get a message when opening a second Excel file.

File in Use

PERSONAL.XLS is locked for editing
By John Smith

Options - Read Only_ Notify _Cancel

I can just click Notify and carry on. Is it possible to avoid this message appearing?

This was not a problem with Office 2003


Noldi

  VoG II 09:57 13 Oct 09

That error will occur if you open two instances of Excel instead of opening two workbooks in the same instance of Excel.

  Noldi 10:30 13 Oct 09

The problem is then with the way Excel is set up then I suppose, I notice if you close a workbook it closes but leaves the main Excel window blank without a workbook showing. Most of my workbooks are via short cuts on the task bar???.

Strange

Noldi

  VoG II 10:39 13 Oct 09

Yes it is strange.

I will check later when I have access to Excel 2007.

  Noldi 10:51 13 Oct 09

VOG Just for info
Options > Addvanced > General > Use Dynamic Data Exchange (DDE) (check box is not selected).

This is the first thing I checked.

Noldi

  VoG II 17:53 13 Oct 09

I can't find any setting in Excel that would cause this behaviour.

Try asking here click here

  Noldi 17:59 13 Oct 09

Ill also speak with the IT guys and gals to see if they have any idea. I thought it was just a missed checked or unchecked box in options.

Noldi

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Animator Emanuele Kabu’s psychedelic video is a stunning tribute to Lisbon city

Best Mac antivirus 2017