Problem -- Personal.XLS is being modified message keeps poping up.

When I open any workbook using Excel 97 and then try to open another
instance of Excel, I always get a message saying something like, "
Personal.xls is being modified by 'me' ."  I certainly am not
deliberately modifying personal.xls.  When I change its attribute to
'read only' this does not happen.

Can someone tell me what might be causing this message by trying to
modify personal.xls and what I can do about it?

Thank you.


0
XXXXXXXX (110)
7/30/2004 3:52:04 PM
excel 39879 articles. 2 followers. Follow

6 Replies
625 Views

Similar Articles

[PageSpeed] 11

A follow on to this problem.

With no other instance of Exel running that I am able to detect, if I
try to open personal.xls, I get a message that says something like this,
"you cannot run two copies of the same worksheet."

Thanks again.

"Jack Gillis" <XXXXXXXX@widomaker.com> wrote in message
news:10gkrl5b621ccf3@corp.supernews.com...
> When I open any workbook using Excel 97 and then try to open another
> instance of Excel, I always get a message saying something like, "
> Personal.xls is being modified by 'me' ."  I certainly am not
> deliberately modifying personal.xls.  When I change its attribute to
> 'read only' this does not happen.
>
> Can someone tell me what might be causing this message by trying to
> modify personal.xls and what I can do about it?
>
> Thank you.
>
>


0
XXXXXXXX (110)
7/30/2004 3:59:44 PM
Hi

Personal.xls is the workbook where you usually store macros. It will be in
your XLStart folder which means that whenever you start XL, it will open -
and your macros will be available. When you try to start another instance of
XL it tries to open personal.xls again - and reports that it is already
open.

-- 
Andy.


"Jack Gillis" <XXXXXXXX@widomaker.com> wrote in message
news:10gks3jfp8atjcd@corp.supernews.com...
> A follow on to this problem.
>
> With no other instance of Exel running that I am able to detect, if I
> try to open personal.xls, I get a message that says something like this,
> "you cannot run two copies of the same worksheet."
>
> Thanks again.
>
> "Jack Gillis" <XXXXXXXX@widomaker.com> wrote in message
> news:10gkrl5b621ccf3@corp.supernews.com...
> > When I open any workbook using Excel 97 and then try to open another
> > instance of Excel, I always get a message saying something like, "
> > Personal.xls is being modified by 'me' ."  I certainly am not
> > deliberately modifying personal.xls.  When I change its attribute to
> > 'read only' this does not happen.
> >
> > Can someone tell me what might be causing this message by trying to
> > modify personal.xls and what I can do about it?
> >
> > Thank you.
> >
> >
>
>


0
Andy
7/30/2004 4:05:23 PM
<Andy B> wrote in message news:#AAjD8kdEHA.2384@TK2MSFTNGP09.phx.gbl...
> Hi
>
> Personal.xls is the workbook where you usually store macros. It will
be in
> your XLStart folder which means that whenever you start XL, it will
open -
> and your macros will be available. When you try to start another
instance of
> XL it tries to open personal.xls again - and reports that it is
already
> open.
>
> --
> Andy.

Thank you very much, Andy.

That makes sense!  Why didn't I think of it.  However, that leaves me
still wondering who or what is trying to modify it as I posed in my
first post in this thread.

Jack


>
>
> "Jack Gillis" <XXXXXXXX@widomaker.com> wrote in message
> news:10gks3jfp8atjcd@corp.supernews.com...
> > A follow on to this problem.
> >
> > With no other instance of Exel running that I am able to detect, if
I
> > try to open personal.xls, I get a message that says something like
this,
> > "you cannot run two copies of the same worksheet."
> >
> > Thanks again.
> >
> > "Jack Gillis" <XXXXXXXX@widomaker.com> wrote in message
> > news:10gkrl5b621ccf3@corp.supernews.com...
> > > When I open any workbook using Excel 97 and then try to open
another
> > > instance of Excel, I always get a message saying something like, "
> > > Personal.xls is being modified by 'me' ."  I certainly am not
> > > deliberately modifying personal.xls.  When I change its attribute
to
> > > 'read only' this does not happen.
> > >
> > > Can someone tell me what might be causing this message by trying
to
> > > modify personal.xls and what I can do about it?
> > >
> > > Thank you.
> > >
> > >
> >
> >
>
>


0
XXXXXXXX (110)
7/30/2004 5:23:33 PM
Jack,

Time for some ritual.  Try this:

Start - Run - type: excel /regserver

This resets Excel's registry entries.

-- 
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jack Gillis" <XXXXXXXX@widomaker.com> wrote in message
news:10gl10mdo080i15@corp.supernews.com...
>
> <Andy B> wrote in message news:#AAjD8kdEHA.2384@TK2MSFTNGP09.phx.gbl...
> > Hi
> >
> > Personal.xls is the workbook where you usually store macros. It will
> be in
> > your XLStart folder which means that whenever you start XL, it will
> open -
> > and your macros will be available. When you try to start another
> instance of
> > XL it tries to open personal.xls again - and reports that it is
> already
> > open.
> >
> > --
> > Andy.
>
> Thank you very much, Andy.
>
> That makes sense!  Why didn't I think of it.  However, that leaves me
> still wondering who or what is trying to modify it as I posed in my
> first post in this thread.
>
> Jack
>
>
> >
> >
> > "Jack Gillis" <XXXXXXXX@widomaker.com> wrote in message
> > news:10gks3jfp8atjcd@corp.supernews.com...
> > > A follow on to this problem.
> > >
> > > With no other instance of Exel running that I am able to detect, if
> I
> > > try to open personal.xls, I get a message that says something like
> this,
> > > "you cannot run two copies of the same worksheet."
> > >
> > > Thanks again.
> > >
> > > "Jack Gillis" <XXXXXXXX@widomaker.com> wrote in message
> > > news:10gkrl5b621ccf3@corp.supernews.com...
> > > > When I open any workbook using Excel 97 and then try to open
> another
> > > > instance of Excel, I always get a message saying something like, "
> > > > Personal.xls is being modified by 'me' ."  I certainly am not
> > > > deliberately modifying personal.xls.  When I change its attribute
> to
> > > > 'read only' this does not happen.
> > > >
> > > > Can someone tell me what might be causing this message by trying
> to
> > > > modify personal.xls and what I can do about it?
> > > >
> > > > Thank you.
> > > >
> > > >
> > >
> > >
> >
> >
>
>


0
nowhere1083 (630)
7/30/2004 9:59:56 PM
A visit to Debra Dalgleish's site might be in order:
http://www.contextures.com/xlfaqApp.html#AlreadyOpen


Jack Gillis wrote:
> 
> <Andy B> wrote in message news:#AAjD8kdEHA.2384@TK2MSFTNGP09.phx.gbl...
> > Hi
> >
> > Personal.xls is the workbook where you usually store macros. It will
> be in
> > your XLStart folder which means that whenever you start XL, it will
> open -
> > and your macros will be available. When you try to start another
> instance of
> > XL it tries to open personal.xls again - and reports that it is
> already
> > open.
> >
> > --
> > Andy.
> 
> Thank you very much, Andy.
> 
> That makes sense!  Why didn't I think of it.  However, that leaves me
> still wondering who or what is trying to modify it as I posed in my
> first post in this thread.
> 
> Jack
> 
> >
> >
> > "Jack Gillis" <XXXXXXXX@widomaker.com> wrote in message
> > news:10gks3jfp8atjcd@corp.supernews.com...
> > > A follow on to this problem.
> > >
> > > With no other instance of Exel running that I am able to detect, if
> I
> > > try to open personal.xls, I get a message that says something like
> this,
> > > "you cannot run two copies of the same worksheet."
> > >
> > > Thanks again.
> > >
> > > "Jack Gillis" <XXXXXXXX@widomaker.com> wrote in message
> > > news:10gkrl5b621ccf3@corp.supernews.com...
> > > > When I open any workbook using Excel 97 and then try to open
> another
> > > > instance of Excel, I always get a message saying something like, "
> > > > Personal.xls is being modified by 'me' ."  I certainly am not
> > > > deliberately modifying personal.xls.  When I change its attribute
> to
> > > > 'read only' this does not happen.
> > > >
> > > > Can someone tell me what might be causing this message by trying
> to
> > > > modify personal.xls and what I can do about it?
> > > >
> > > > Thank you.
> > > >
> > > >
> > >
> > >
> >
> >

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
7/30/2004 10:34:34 PM
"Earl Kiosterud" <nowhere@nowhere.com> wrote in message
news:OoBpOCodEHA.3944@tk2msftngp13.phx.gbl...
> Jack,
>
> Time for some ritual.  Try this:
>
> Start - Run - type: excel /regserver
>
> This resets Excel's registry entries.
>
> --
> Earl Kiosterud
> mvpearl omitthisword at verizon period net
> -------------------------------------------

Thank you, Earl.  That was the first thing I tried for I have
encountered this before when opening a 'normal' workbook.  This time to
no avail.

>
> "Jack Gillis" <XXXXXXXX@widomaker.com> wrote in message
> news:10gl10mdo080i15@corp.supernews.com...
> >
> > <Andy B> wrote in message
news:#AAjD8kdEHA.2384@TK2MSFTNGP09.phx.gbl...
> > > Hi
> > >
> > > Personal.xls is the workbook where you usually store macros. It
will
> > be in
> > > your XLStart folder which means that whenever you start XL, it
will
> > open -
> > > and your macros will be available. When you try to start another
> > instance of
> > > XL it tries to open personal.xls again - and reports that it is
> > already
> > > open.
> > >
> > > --
> > > Andy.
> >
> > Thank you very much, Andy.
> >
> > That makes sense!  Why didn't I think of it.  However, that leaves
me
> > still wondering who or what is trying to modify it as I posed in my
> > first post in this thread.
> >
> > Jack
> >
> >
> > >
> > >
> > > "Jack Gillis" <XXXXXXXX@widomaker.com> wrote in message
> > > news:10gks3jfp8atjcd@corp.supernews.com...
> > > > A follow on to this problem.
> > > >
> > > > With no other instance of Exel running that I am able to detect,
if
> > I
> > > > try to open personal.xls, I get a message that says something
like
> > this,
> > > > "you cannot run two copies of the same worksheet."
> > > >
> > > > Thanks again.
> > > >
> > > > "Jack Gillis" <XXXXXXXX@widomaker.com> wrote in message
> > > > news:10gkrl5b621ccf3@corp.supernews.com...
> > > > > When I open any workbook using Excel 97 and then try to open
> > another
> > > > > instance of Excel, I always get a message saying something
like, "
> > > > > Personal.xls is being modified by 'me' ."  I certainly am not
> > > > > deliberately modifying personal.xls.  When I change its
attribute
> > to
> > > > > 'read only' this does not happen.
> > > > >
> > > > > Can someone tell me what might be causing this message by
trying
> > to
> > > > > modify personal.xls and what I can do about it?
> > > > >
> > > > > Thank you.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


0
XXXXXXXX (110)
7/30/2004 11:50:20 PM
Reply:

Similar Artilces:

Keep a running total while using a clearable form
I have a form that I am able to clear with a macro reset button. How can I keep a record of the values within the form and add them to the previous values that were in that same form before I press the reset button? I want to keep a running total log is what I guess I'm trying to say. Hi Have a look here: http://www.mcgimpsey.com/excel/accumulator.html It is well worth reading the intro, as it mentions the lack of traceability should you enter an incorrect number. Hope this helps. Andy. "1vagrowr" <1vagrowr@discussions.microsoft.com> wrote in message news:A93475...

Can't open email messages
The layout: Exchange 2003 SP2 w/OWA Outlook 2003 SP2 I can connect to the email server with my Outlook client. I can open all emails prior to Tuesday and perform all email functions (reply, forward, etc). Since Tuesday, I cannot open or perform any email functions with any messages. I see who the message is from, the subject, and date/time stamp. The message is gray'ed out in the Preview Pane and states "This item cannot be displayed in the reading pane...". Likewise, when I try to open the message, it states "Can't open this item". I'm leaning towar...

personalized mail
hello, i'm using outlook xp. how can i do to personalized my outgoing mail with my logotype and other graphical informations? thanks denis Hi Denis, You can either use an HTML file, or create a signature. The latter is probably easier. Tools >> Options > Mail Format tab. Click Signatures at the bottom, create a new sig. Give it a name. Once in, if you want anything jazzy, pressing Advanced Edit will open up either FrontPage or Word, depending on your PC config. You can add lots of pics and other more complex components from here. Hope this helps Piers "denis" &l...

People sending me mail get mailbox full message
I know my mailbox is not full, it's a brand new computer and i maybe have 10 messages. People sending me email get the message yet I don't get any such message on my end. Where can I go to see if I'm actually out of space and/or increase the space? Help anyone. On Tue, 27 Jan 2004 07:31:06 -0800, "Tony" <anonymous@discussions.microsoft.com> wrote: >I know my mailbox is not full, it's a brand new computer and i maybe >have 10 messages. People sending me email get the message yet I >don't get any such message on my end. Where can I go to see if...

imap security problem ?
I recently ran a port scanner /tcp viewer on a win2k server that has exchange configured on it. An MX record was created for that machine at the ISP so that all emails get delivered directly to it. Now the port scanner / tcp viewer is reporting a constant TCP connection between port 143 on the server and another machine -which is NOT the ISP. What am I seeing, a security hole ? Should port 143 even be open ? Where can I look for that in the exchange setup ? If you're not using imap you should stop & disable the IMAP sevice. You should also deny 143 at the firewall. >-----Origi...

Strange problem #2
User is running Excel 2002. Her normal routine is to open Excel, then open 8 different files (all linked to other files). As worked is completed on each file, files is saved and closed so Excel never has more than one file open at any given time. Excel shuts down every morning after she runs the 3rd or 4th file with various errors. If she runs this routine by opening Excel and then closing it after each file - the errors don't occur. So as long as she closes Excel after she runs each file and starts a new session for the next file - everything runs smoothly. Any ideas? Do ...

Why does my computer keep freezing?
When I am playing games on face book,, my computer freezes up.. WHat can I do You can try posting your question in an appropriate newsgroup. Your problem has nothing to do with Word. I would suggest starting with Facebook's tech support. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "nana" <nana@discussions.microsoft.com> wrote in message news:B1513814-8C77-4419-BA1A-51760CB802B6@microsoft.com... > When I am playing games on face book,, my computer freezes up.. WHat can I > do ...

In Outlook 2003 how I keep IMAP messages for long?
I set up an IMAP folder which keeps only the last week's mails and does NOT display older ones. Incidentally it's the only account that does this to me while other IMAP accounts dont. There's no apparent setting in Outlook 2003 that I can use, is there? I'm probably off base, but it sounds like you set a view to only display the last weeks worth of e-mail. Did you do something like this via the view menu? "lamdig" <lamdig@discussions.microsoft.com> wrote in message news:00CDB83D-DB26-484A-B14D-3F4DD69FB64F@microsoft.com... >I set up an IMAP...

Modifying a hosted SRS-Report (.rdl) -> subreport could not be sho
Hi, - MSD 4.0, hosted. - I downloaded "Invoice Sub-Report.rdl" (via Edit Report|Actions|Download Report) - Edited that in VS2005, - (could have been a text editor as well) - for grouping on product <CommandText> SELECT FilteredInvoiceDetail.productidname, FilteredInvoiceDetail.productdescription, . FilteredInvoiceDetail.quantity, /*SUM(FilteredInvoiceDetail.quantity) AS quantity, */ . FROM FilteredInvoiceDetail LEFT OUTER JOIN FilteredProduct ON FilteredInvoiceDetail.productid = FilteredProduct.productid WHERE (FilteredInvoiceDetail.invoiceid = @CRM_Qu...

outlook XP: blocking email messages with a certain hyperlink
I have gotten my main e-mail onto a spammer's list that does not respect wishes to be removed. It is casino, pills, etc, all from one spammer, using multiple free addresses to spam me. One common factor is the unsuscribe link in the html email always leads to "vpillz.globalofferz.biz". Is there any way to tell Outlook to trash any messages containing a link to that page? ...

Keeps saving a CD copy
The last time I saved a back-up file (of my Money 2002 file), I was out of floppies, so I saved it to a CD. Now, every time I open Money it places a copy of the same file in the CD burner, even though I select "Do not back up" and there isn't even a CD in the drive. HOw can I make it stop this?? Thanks -- this is a great forum. In microsoft.public.money, Connie wrote: >The last time I saved a back-up file (of my Money 2002 >file), I was out of floppies, so I saved it to a CD. Now, >every time I open Money it places a copy of the same file >in the CD burner, ...

Xpath problems #2
Hi, I'm trying to display the data from my typed dataset on a page using the Xml web control. I have the following code: Xm1.Document = new XmlDataDocument(ds); Using the debugger, I found that the xml representation of my dataset looks like the following: [code:1:877c35039f] <dsData> <Entry> <Title>Test</Title> <Description>This is a test</Description> </Entry> </dsData> [/code:1:877c35039f] My xsl file looks like this [code:1:877c35039f] <?xml version="1.0" encoding="ISO-8859-1"?> <xsl:stylesheet...

Case Statement Problem
Hello, Can someone please help me with my Case Statement Public Function FEE_TYPE(DET_REF As String) As String Dim strRef As String Dim strFeeType As String strRef = DET_REF Select Case strRef Case "LP*" strFeeType = "LP" Case "PP*" strFeeType = "PPP" Case "Prop*" strFeeType = "Prop Tax" End Select FEE_TYPE = strFeeType End Function Query SELECT FEE_CATEGORY: FEE_TYPE(DET_REF) FROM tblFees I do not get any results when I know there are many of them :( Try this: Pu...

A really interesting Outlook problem!
Hello everybody! I've got an interesting Outlook file (112 KB RAR-ed) which shows the following behavior: when you open it (i tried Outlook 2003), it shows up OK, but no item could be deleted or moved. It tells "Errors have been detected in your Outlook data file, close all programs and use the Inbox repair tool". But scanpst (Inbox Repair Tool) finds absolutely no problem even with -logv 9, the most detailed one. What can you suggest me to do? Here is the link to the file: http://www.anovikov.com/StrangeFile.rar Are there any Microsoft people out here? By looking at...

Index and some other web page problems
I have had occasional problems with index publishing on filezilla. My webhost doesn't think frontpage is secure with extensions. I have no extensions according to them but I must download from filezilla. What is baffling is that my index doesn't always update to them. My webpages do, sometimes, sometimes not. I have tried save as the filename to my f/documents/website/index and still when I update filezilla it shows the previous date still. Even after reboots the next day. What can I do to know that my frontpage is updating to my downloader? I'm really a novic...

Sync CRM 3.0 with Outlook 2007 problem
Hello. At synchronization CRM of the client with Outlook, in added contacts in Outlook the organization to which this contact concerns does not appear in Outlook card. How it can be corrected? Hi Dmitry, this should be able to help: http://www.workopia.com/howto/DisplayParentAccountOutlookContactForm.htm. If not then take a look at http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=85B6BEED-3212-48C1-9634-BAACAC74A16A Hope this helps -- George Doubinski CRM Certified Professional - Developer "Dmitry" <Dmitry@discussions.microsoft.com> wrote in mes...

Problem when registering OCX
This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C3EA6F.B5037D00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a problem that occurs when building an ActiveX OCX that uses MFC. = What happens is that after the OCX is linked, VS.NET 2003 attempts to = register the OCX via regsvr32 and fails with a very unhelpful message = stating... Project : error PRJ0019: A tool returned an error code from "Performing = registration" An important thing to note is that this ONLY happens when statically = linki...

Design problem: Excel publishing data back to a web site
Hi All, This is a request for advice on Excel and data connectivity over the web. I am looking to add a feature to a web site (& web service) that has a large but simple data set (imagine 5000 rows of data). I want users to be able to download this dataset to their client machine (in some form such as xml or even csv) where they can manipulate this data locally, and then _upload_ this modified data back to the web site. One unsatisfactory approach to doing this is to present the user with a url where they can download the data, modify it and save it to a local file, then upload this fi...

I cannot read forwarded messages. I only get an email address
For some reason, when someone forwards a message to me all that shows up is the email address of the person who originally sent the message. Any ideas? Change your View>Encoding setting. "Michelle10000" wrote: > For some reason, when someone forwards a message to me all that shows up is > the email address of the person who originally sent the message. Any ideas? ...

personal.xls won't open when I start Excel
Recently, the personal.xls file won't open when I start Excel. The box for "Open all files in " on the general tab under tools/options is blank. When I've tried to change this to the Microsoft Excel startup directory (C:\Documents and Settings\MyName\Application Data\Microsoft\Excel\XLSTART), which does have the personal.xls fiel in it, it won't let me. As soon as I click OK, it reverts back to a blank box. Any ideas? This is a recent phenomena, as it worked fine for the past 9 months and don't really have any idea as to what I might have changed (if anyth...

Add-in problem
On trying to create the first email message each time after starting Outlook 2007, I get the following message: The Add-inn "FaxExtension" (C:\Windows\System32\fxsext32.dll) cannot be loaded and has been disabled by Outlook. Please contact the Add-in manufacturer for an update. If no update is available, please uninstall the Add-in. After clicking the OK button on the messsage everything works fine. I have looked at the Add-ins in Outllook (Tools>Trust Center>Add-ins) but don't see this add-in, nor can I find the fxsext32.dll in the System32 folder. I had tried ...

No Messages in Inbox
I can send email, but cannot receive it. The Exchange account is valid, but I am not receiving any email. Any ideas? Need more info - if you're using Exchange, are you opening up the Exchange mailbox directly? what services do you have loaded? What version of Outlook? Have you checked your view settings on the inbox? Have you asked your Exchange admins for help? Brian wrote: > I can send email, but cannot receive it. The Exchange > account is valid, but I am not receiving any email. Any > ideas? ...

Problem with Local time to System time conversion
Hi, Any help would be much appreciated, and here's my problem: I've used the function SystemTimeToTzSpecificLocalTime() to convert a UTC based time to a local time and everything works fine. However,when I try to do the reverse, that is, from a local time back to a UTC time. The function TzSpecificLocalTimeToSystemTime(); is not supported under windows 2000 (only supported on XP/server2003) So I tried the function FileTimeToLocalFileTime() as a work-around but my time is always off by one hour because of daylight saving. Are there any easier alternatives besides making my own timezo...

Excel VBA-vlookup combo box problem
Hi can someone please help me. I have created a worksheet in which i have Vlookup formulaes reading o another worksheet which has combobox with drop down lists and linke cells. Everything works apart from the comboboxes whose populate linked cells are not being recognised by the v-lookup function. Th Vlookup is as follows: vlookup(e18,'policy'!c5:098,7,false) The data within the combo box is a mixture of text and numerical e. L32H11-1, EM2H11-1 I have put a double minus sign in front of e18 and it returns #value! Can someone please help me. thanking you in anticipation Saik ...

Latitude and Longitde problem
Hi all Just wondering if somebody can help me with a problem. I need to calculate the distance between two latitude and longitude co-ordinates. Is there a function I can use? The lat. and long. co-ordinates are expressed as decmals and not deg, mins and secs. Any help will be appreciated. Thanks Francois see www.cpearson.com where Chips has lots on lat & long. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Francois Ashton" <francois@vitria.co.za> wrote in message news:%23OAAW7uCGHA.4016@TK2MSFTNGP11.phx.gbl... > Hi al...