Re: Excel Denying Access to Workbook that I Own



On Jul 31, 12:05 pm, thefro...@xxxxxxxxx wrote:
All,

This is on a new 15" ibook that had it's files and programs
transferred from an old 12" Powerbook. It's using Excel 2004 for Mac
(which, by the way, is telling me it's a test drive with 30 days
left.)

I have a 9.6MB workbook in a shared folder on a Windows server. I log
in as a valid user of the Windows domain, navigate to the workbook and
double-click it. Excel opens it. I pick an empty cell and enter some
text and hit Save. Excel's progress bar runs a bit and then stops and
tells me it cannot save the changes to the file, and the changes have
been saved to a file called, e.g. 24689000. I'm supposed to open that
file and re-name it.

If I close everything and try to open the original file Excel tells me
it can't access the read-only file. The Mac tells me I have read and
write permissions for the workbook and I have read and write
permissions for the share on the server. If I repeat this process with
24689000 then *it* will be saved to another file and I loose access to
it too, although I continue to have read and write access to it.

This workbook is password protected, and I know that too. What is
going on? Does Excel for Mac have a file size limit as small as 10MB?
Or is this surprising "test drive" state causing problems?

thx,

r

More information;

I've just discovered that, on the server, there is what I will call a
lock file of the format "._<filename>.xls". Something like:

.._bigwork.xls

It has some weird binary data in it (so says notepad). There is no
file like this for the file I'm having trouble with and I'm betting
this is why. I've had a user on another laptop (Windows XP) try to
open it and they could not, they get an error about the file not being
found or having been moved. My question is, are there any
circumstances where user activity might cause this dot file to be
deleted even though the actual workbook is present and/or open? Could
such a thing happen if there were multiple users? Perhaps someone
having the file open and then closing their laptop and going home for
the day

thx,

r

.



Relevant Pages

  • Re: #NAME?
    ... So I'm not exactly sure why this file opens fine in prior versions of Excel ... I also find some formulas are used in this workbook. ...
    (microsoft.public.excel.setup)
  • RE: Print row when cell in one column blank
    ... I open EXCEL - it automatically loads PERSONAL.xlsb ... it closes Workbook KKK.xlsx - which it should ... Joel, I hope I have explained the situation clearer than before. ... from a macro it opens in the same instance of excel. ...
    (microsoft.public.excel.programming)
  • Re: Prevent automatic calculation for workbook being opened
    ... The bad news is that excel picks up this setting from the first workbook it ... So if they open a workbook that's been saved in manual calculation mode first, ... When the addin opens, the ...
    (microsoft.public.excel.programming)
  • Re: Opening Excel
    ... True *.xlt files will not open when Excel starts. ... Re-create a workbook with some formatting etc. and File>Save As>File ... If you truly saved a BOOK.XLT as a Template in your XLSTART folder, ... the blank workbook that opens. ...
    (microsoft.public.excel.setup)
  • Re: error message
    ... I don't know what was causing that particular workbook to attach itself to ... every excel file I was saving but after I repaired my Excel and shut down my ... "Dave Peterson" wrote: ... I have an EXcel file that every time opens gives me a error message telling ...
    (microsoft.public.excel.misc)