Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
Course Of The Month
2 days, 2 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Windows 7, Excel 2007, Sync'ing 2003 xls files problem
Posted on 2011-09-15
Hi,
I have had this problem for a few years now and I cannot seem to find a fix for it.
More and more it becomes an annoyance for my co-workers and I thought I would throw the question in here once again.
I am having a problem where files saved in excel 2003 format by an Win7/Excel2007 client to a Terrastation server (irrelavant as it happens on 2k3 server also), failes to synchronise and ALWAYS ends up OFFLINE.
Even simply opening the .xls in Excel 2007 renders the file offline.
A manual sync is then required for the rest of the office to see the file on the server.
This does NOT happen to Excel 2007 format files saved to the same location using the same machine.
I think a longer explanation is here: http://forums.techarena.in/vista-help/887452.htm
I didn't have this problem with XP Pro/Office 2003, but I have had the same problem with Vista/Office 2007.
Something tells me that the way Excel 2007 saves the 2003 format file is stopping sync center from allowing it to sync.
I can performa manual sync and it goes back online (until you open it in Excel 2007 again)
Can someone PLEASE help. This issue has been a problem in my network for ages, and I thought upgrading to 2010 would fix it, but it hasn't.
HELP.
Thanks,
Marty
I have had this problem for a few years now and I cannot seem to find a fix for it.
More and more it becomes an annoyance for my co-workers and I thought I would throw the question in here once again.
I am having a problem where files saved in excel 2003 format by an Win7/Excel2007 client to a Terrastation server (irrelavant as it happens on 2k3 server also), failes to synchronise and ALWAYS ends up OFFLINE.
Even simply opening the .xls in Excel 2007 renders the file offline.
A manual sync is then required for the rest of the office to see the file on the server.
This does NOT happen to Excel 2007 format files saved to the same location using the same machine.
I think a longer explanation is here: http://forums.techarena.in/vista-help/887452.htm
I didn't have this problem with XP Pro/Office 2003, but I have had the same problem with Vista/Office 2007.
Something tells me that the way Excel 2007 saves the 2003 format file is stopping sync center from allowing it to sync.
I can performa manual sync and it goes back online (until you open it in Excel 2007 again)
Can someone PLEASE help. This issue has been a problem in my network for ages, and I thought upgrading to 2010 would fix it, but it hasn't.
HELP.
Thanks,
Marty
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
6-
6
- +1
17 Comments
Active today
I don't think I have a fix for you but it sounds like the same problem I've seen with shared files. We have some files created by Excel 2007 and when opened in 2003 while someone else has it opened, it seems to lock it permanently.
The solutions seem to be having the 2003 file get exclusive access to this file while nobody else is using it, or to upgrade from 2003 to 2007/2010.
What I am not sure is if the file was created by 2003 then used by 2007 simultaneously with 2003.
The solutions seem to be having the 2003 file get exclusive access to this file while nobody else is using it, or to upgrade from 2003 to 2007/2010.
What I am not sure is if the file was created by 2003 then used by 2007 simultaneously with 2003.
Whilst I agree we can now use 2007 format for future files, which I have instructed the office to do. It would be impossible to go over all the 2003 format files and convert them to 2007. Also, when we receive a 2003 file from external sources, to make sure we keep integrity with the external source, we wouldn't be able to convert it to 2007.
XP and 2003 didn't have this problem, so it's something that is only in vista / win 7 and Office 2007 / 2010.
Thanks,
Marty
XP and 2003 didn't have this problem, so it's something that is only in vista / win 7 and Office 2007 / 2010.
Thanks,
Marty
Active today
Yes, and I've heard others with the problem and assume it is a Microsoft bug, and from what I hear, they don't seem very anxious to acknowledge or fix this.
Active today
I've requested that this question be deleted for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Don't delete it as it is an unanswered question and one that I feel is important.
There is a clear flaw in the software.
There is a clear flaw in the software.
Active today
I agree...there is value in unanswered questions like this since at some point Microsoft may properly acknowledge this as a bug so anyone who experiences it can at least know it's a real problem.
I suggest PAQ with 0 points.
I suggest PAQ with 0 points.
I've requested that this question be closed as follows:
Accepted answer: 0 points for marty_t's comment http:/Q_27309661.html#36950193
for the following reason:
To keep the question in the KB
Accepted answer: 0 points for marty_t's comment http:/Q_27309661.html#36950193
for the following reason:
To keep the question in the KB
Active today
I've objected to your action, since your choice of a "solution" is not a valid technical solution. While i understand your intent, please note that EE does not allow you to accept invalid, non-technical comments to your question.
If you wish to maintain this content, then you might consider making a copy of the question (i.e. just copy the content) and save it to your local machine. This will allow you to refer to the comments as needed.
However, I would suggest that if you have found value in this, then perhaps you have received some form of "assistance" from the Experts, and therefore could accept one or more of their solutions as an Assisted solution - that would satisfy the EE policy, and would allow you to maintain this question in the PAQ. It's understandable that some issue take several "steps" to resolve.
SouthMod
EE Moderator
If you wish to maintain this content, then you might consider making a copy of the question (i.e. just copy the content) and save it to your local machine. This will allow you to refer to the comments as needed.
However, I would suggest that if you have found value in this, then perhaps you have received some form of "assistance" from the Experts, and therefore could accept one or more of their solutions as an Assisted solution - that would satisfy the EE policy, and would allow you to maintain this question in the PAQ. It's understandable that some issue take several "steps" to resolve.
SouthMod
EE Moderator
Active today
South, not to be picky about this, but Marty is trying to follow the rules you (EE) defined and you keep overriding him.
First, he wanted to leave this open until we got an answer and you said he couldn't but he could pick a solution of his choice, then you say his choice is not good enough.
In my opinion, the answer I gave is valid, but does not really offer a solution, leaving us in this quandry. The answer allows future viewers to see that there really IS NO ANSWER, and that, in itself is a valid answer but not necessarily worth the price paid.
The original selection by Marty was valid: "There is a clear flaw in the software."
And an assist can go to ID 36556794.
Would this put it to rest, or would it then be opened again? Please let this question get PAQ'd
First, he wanted to leave this open until we got an answer and you said he couldn't but he could pick a solution of his choice, then you say his choice is not good enough.
In my opinion, the answer I gave is valid, but does not really offer a solution, leaving us in this quandry. The answer allows future viewers to see that there really IS NO ANSWER, and that, in itself is a valid answer but not necessarily worth the price paid.
The original selection by Marty was valid: "There is a clear flaw in the software."
And an assist can go to ID 36556794.
Would this put it to rest, or would it then be opened again? Please let this question get PAQ'd
I found what the problem was.
http://support.microsoft.com/kb/2002109
AND it comes with a FIX!!! FINALLY!!
http://support.microsoft.com/kb/2002109
AND it comes with a FIX!!! FINALLY!!
Active today
Excellent Marty! Sorry it took MS so long to fix this, but glad you can now move forward with it.
Active today
Usually once a question is marked as solved, you won't be able to re-mark it. I think that with this link at the bottom of this thread, people will find it:
SOLUTION IS HERE: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27309661.html#a38758803
SOLUTION IS HERE: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27309661.html#a38758803
Featured Post
Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Suggested Courses
Course of the Month2 days, 2 hours left to enroll
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.