Replies

In Excel Ctrl+Scoll changes the size of all the cells.
Boy the wheels are really turning now.

If someone opens up a shared workbook that someone else already has open you can only open it “read only” and no changes can be saved. If the Auto Save is running only the first person can save changes.
Are you trying to have a read only workbook open and see changes made by the person who is “allowed” to make changes?

You click Data–Get External Data–New Database Query, then choose New Data Source ande click OK.
You then give it a name. In the box below that you select the driver. We use Pervasive SQL and it comes with it’s own unique driver. Choose the SQL driver right for you and click OK.
The next screen will ask for the data path. You can browse to the .DAT file of your software or enter it (serverprogramfile.dat as an example) and you also enter your user name and password in this screen as well.
The next time you wnat to get some data you click Data–New Database Query and select the the one that you just created, you won’t have to worry about a password again. When you get this far the Query Wizard will guide you through the rest.
You might also want to check for a Database Reference Guide for your software. The Query Wizard will give you the headings of the data that you choose to pull up , but some companies make their headings self explanitory while others make thier headings vague to say the least.
Let me know if you get stuck.

You click Data–Get External Data–New Database Query, then choose New Data Source ande click OK.
You then give it a name. In the box below that you select the driver. We use Pervasive SQL and it comes with it’s own unique driver. Choose the SQL driver right for you and click OK.
The next screen will ask for the data path. You can browse to the .DAT file of your software or enter it (serverprogramfile.dat as an example) and you also enter your user name and password in this screen as well.
The next time you wnat to get some data you click Data–New Database Query and select the the one that you just created, you won’t have to worry about a password again. When you get this far the Query Wizard will guide you through the rest.
You might also want to check for a Database Reference Guide for your software. The Query Wizard will give you the headings of the data that you choose to pull up , but some companies make their headings self explanitory while others make thier headings vague to say the least.
Let me know if you get stuck.

Web Queries are meant to pull data off of a web page whenever you would like, for example, getting stock prices every 10 minutes. The problem is that the links aren’t data and therefore are not being downloaded into Excel. You can however set query to pull the entire page in HTML and it will pull the links as well but you won’t be able to see the information from the link until you click it.
What is it in particular are you trying to accomplish?

Web Queries are meant to pull data off of a web page whenever you would like, for example, getting stock prices every 10 minutes. The problem is that the links aren’t data and therefore are not being downloaded into Excel. You can however set query to pull the entire page in HTML and it will pull the links as well but you won’t be able to see the information from the link until you click it.
What is it in particular are you trying to accomplish?

Are you putting the quotation marks into the formula? The correct formula would be

=DATEDIF(A1,B1,”d”)

Are you putting the quotation marks into the formula? The correct formula would be

=DATEDIF(A1,B1,”d”)

Can you give me the web page you’re trying to get the data from?

Can you give me the web page you’re trying to get the data from?

D’ Oh! Thanks for correcting my brain cramp!!

D’ Oh! Thanks for correcting my brain cramp!!

Have you tried using MS Query instead of importing to get the info from the SQL database? With MS Query you enter the user name and password when you first set up the query and you don’t have to worry about it again.

Have you tried using MS Query instead of importing to get the info from the SQL database? With MS Query you enter the user name and password when you first set up the query and you don’t have to worry about it again.

Format col A & B to the appropriate time format and format col C to “number” format with two decimal places. In C1 enter =B1-A1*24
Excel stores times based on a percentage of the day so 6:00 PM equals 0.75 to Excel. So by figuring out the difference and mulitplying by 24 it gives you the elapsed time in a numeric format instead of a time format.