BigWindow

I sent the processmon log files to you directly via email.

I understand what you are saying about the file going offline when
opened, but it doesn't make too much sense to me that this is the case
ONLY for XLS files and NOT for the new native format for Excel and
also it is not a problem for Excel 2003. And the root question then,
if Excel 2007 is going to force this one particular file type offline
when opening, why can't it save it anymore?

Looking forward to the answers for this one.


On Jun 5, 2:50 pm, "Shubhankar Sanyal [MSFT]"
<sany...@online.microsoft.com> wrote:
> Hi,
> Processmon can be downloaded from the following location-http://www.microsoft.com/technet/sysinternals/ProcessesAndThreads/pro...
>
> The screen should show you a trace of all I/O operations taking place in the
> system. You should be able to filter by process name (in this case
> excel.exe.) Make sure there are logs for the save operation and then save it
> and then save the log. I realize these instructions are not very detailed.
> However I found processmon pretty intuitive. If you do not find it so, let
> me know and I'll send you more detailed intsructions.
>
> The reason xls files go offline on being opened is due to the way that excel
> opens files over the network. The going offline is to facilitate cache
> coherency. I could let you know a reg key to not make the file go offline,
> however in that case the file instead of going offline would no longer be
> available offline. You would then need to wait for a background sync to get
> file back in the offline files cache.
>
> Thanks,
> Shubhankar
>
> "BigWindow" <rhertz...@eurotoyshop.com> wrote in message
>
> news:1180875542.908755.164040@q75g2000hsh.googlegroups.com...
>
>
>
> > This issue is not yet resolved. We have canned VISTA/Office 2k7 as an
> > organization because of this issue but I still have a developement
> > machine for testing that setup.
>
> > No - the preview pane is not enabled - in fact I didn't even know it
> > was there. And I can give you a processmon log of the save operation
> > if given instructions on how to get it.
>
> > I'm suprised the "going offline is expected" by simply opening the
> > file. Other file types do not immediately go offline when opened -
> > like TXT and even XSLX files, DOC files do not have this same problem
> > in Word 2k7.
>
> > Also, 75% of the time, trying to sync after the file is opened (to
> > bring it back online and work-around the problem) you get a sync error
> > "the process cannot access the file because it is being used by
> > another process". But 25% of the time you actually can perform the
> > sync, bring it back online and then never have a problem saving the
> > file during that session again.
>
> > On Jun 1, 9:18 pm, "Shubhankar Sanyal [MSFT]"
> > <sany...@online.microsoft.com> wrote:
> >> In case this has still not been resolved, please let me know the
> >> following-
> >> 1. Is preview pane enabled in explorer ? (Organize->Layout->Preview Pane)
> >> 2. Will you be able to get us a processmon log of the save operation that
> >> fails?
>
> >> The going offline is expected (this is to prevent data loss. The file
> >> should
> >> go back online by syncing it) However the failure to save is not
> >> expected.
>
> >> Thanks,
> >> Shubhankar
>
> >> "BigWindow" <rhertz...@eurotoyshop.com> wrote in message
>
> >>news:1179801000.190641.57150@p77g2000hsh.googlegroups.com...
>
> >> > Hello~
>
> >> > Have this annoying REPEATABLE problem with Excel 2007 running on
> >> > Vista
> >> > Business saving to a share on Windows Server 2003 (not SBS). On the
> >> > client,
> >> > Vista and Excel all up-to-date with SPs, the machine is part of a
> >> > domain, and some files on different shares are set to be available
> >> > offline.
>
> >> > On the server, Windows 2003 also up-to-date, the client user has full
> >> > permissions in all the directories in question - both share
> >> > permissions and NTFS permissions), and the directory is set to make
> >> > only files users specify to be available offline.
>
> >> > Client has no problem opening and saving files in Excel that are NOT
> >> > marked as available offline. Also no problems with the new native
> >> > file
> >> > format.
>
> >> > So now here is the problem - as soon as a file available offline AND
> >> > in Excel 2003 format is opened by Excel, the properties of that file
> >> > indicate that the file is offline. i.e. the process of opening the
> >> > file moves its status to offline. Then any attempt to save the file
> >> > results in the dreaded "document not saved" error message. This
> >> > occurs
> >> > with a constant dedicated network connection. So, a work around has
> >> > been to save it local and then drag and drop it over to the network
> >> > when finished. Another work around (that works sometimes when Excel
> >> > lets it happen) is to open the properties of the file AFTER opened by
> >> > Excel, hit the [Sync] button to move the file back to online - and
> >> > then for the rest of the session it stays online and you can save it
> >> > at will.
>
> >> > So in summary, it seems that Excel 2007 has the nasty habit of moving
> >> > an XLS document from online to offline upon opening and then cannot
> >> > save it anymore. Anyone else have this issue or a fix? Using Office
> >> > 2007 organization wide hinges on it.
>
> >> > Regards- Hide quoted text -
>
> >> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -