VBA Excel

  Noldi 09:47 13 Oct 2009
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 2009

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 2009

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 2009

Yes it is strange.

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

  Noldi 10:51 13 Oct 2009

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 2009

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

Try asking here click here

  Noldi 17:59 13 Oct 2009

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.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Microsoft Surface Book 2 hands-on review – bigger and 5x faster

Best kids apps for iPhone & iPad

Que faire si son iPhone ou iPad est tombé dans de l'eau ?