Contact Forum Editor

Send an email to our Forum Editor:

PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom

It's free to register, to post a question or to start / join a discussion

View Forum Rules | Contact Forum Editor

 

Excel 2007: Changing units

m800afc

Likes # 0

Posted August 2, 2011 at 11:02PM

Hello all,

I am trying to set up a worksheet using Excel 2007 and Windows 7. I want to replicate a frequently used pre-printed form, so I can print the results into the boxes of the form. The form is pre-printed and I only have the document on paper. I intend to put the form into my printer and then print the excel sheet directly into the original. I am starting a new sheet, and I am not using a template.

When I try to change the units, or anything else for that matter, (Excel Options Advanced) I get a dialog box stating:

"The server drafts location you entered for offline editing is not valid or you do not have permission to access that location. Specify a location on your local computer."

I have no idea what this means or what to do about it. I am the administrator on the computer, which is not on a server or local network.

How may I solve this problem?

Cheers

Like this post
wee eddie

Likes # 0

Posted August 2, 2011 at 11:58PM

Can you not Scan the Form and save it as, say a Word Document, which will accept simple Formulae or use OCR Software to turn it into a Spread Sheet

Like this post
Woolwell

Likes # 0

Posted August 3, 2011 at 11:56AM

Is your problem solved by the answer here link text

Like this post
Woolwell

Likes # 0

Posted August 3, 2011 at 12:00PM

In 2007 it is under Options - save . In my Excel 2007 I have the box save checked out files ticked and the location is sharepoint drafts and I don't have a snag.

Like this post

Reply to this topic

This thread has been locked.



Check out PC Advisor's other tech forums

Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story. Both your name and the recipient's name and address will not be used for any other purpose.