Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

We implemented a fix for this problem a few months ago (provided somewhere on the web by a member of the Excel team), and it worked just fine. Now, it doesn't (we're Army, and all sorts of things keep getting added to our networks).

Now, using either Excel or Access generates the same error:

"Cannot connect to the server at this time. Your table cannot be published."

Any ideas? We're MOSS.

share|improve this question

1 Answer 1

The now standard answer to this problem is to change the value of the lver variable in EXPToOWS.XLA to 2 (or higher). When I did this, I did not bother to comment out the first variable assignment. So, the code reads something like:

lver = [some expression]

and you are supposed to add:

lver = 2

commenting out the first assignment. I did not do so, knowing from standard programming practice that only the final action on a variable counts. Well, either not with Office code or Visual Basic or whatever, because you must comment out the first assignment or the fix doesn't work.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.