I have an Excel file that get data from a  SQL Server Stored Procedure that
is accessed through a SQL Server login. Currently a Login box comes up and I
need to enter the user and password. Is there any way that I can prevent the
login dialog from showing. The SQL Server Login that ...

I accidentally saved a new version of an Excel spreadsheet using the same
file name as the previous version.  Is there any way I can recover the old
version?

I have an Excel file that has two worksheets for sales data.  The first work
sheet has surpassed 65536 lines in Excel 2003 and I've continued the data
into the second worksheet.  I've done some Google searches and they said
theirs a way to combine two work sheets using MS Query and ...

Is there a way to check for dupes over more than one column?
First                Last
Jorge Luis        Menedez
Jorge               Luis Menendez

I am trying to make a spreadsheet of the daily hours worked and a total of
the weekly hours but i am not having any luck, at the moment I have the
following
H3 08:33, H4 08:01, H5 07:23, H6 08:15, H7 08:15, when i type =sum(h3:h7) i

How can I get rid of security dialog which comes up when I open a XLS file
with macros?
Thx
YuriW

I have a sales spreadsheet that is grouped by vendor with customer sales
info under each vendor.  Is there a way to sort the vendor groups
keeping the customer data in each groups as is?
TIA,

I want to know how to do this: JJSMUM2005@hotmail.com:
How to  repeat a row or two as a header on the next page.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

When using an Excel spreadsheet as the data source for mailmerge in
Office 2003 the merged numbers in the Word document are often displayed
with many decimal places. eg. if the number in excel is 2.8 it merges as
2.79999999 in Word.

Now that I have solve courtsey of JE McGimpsey my calculations and
formulas problems, I need to publish a very small web sheet tot eh
web.
What we are tryingg to do is give field agents a web based calculator.

Can you autofill functions to the right, and have it increase the numbers...
for example... in A1 the formula would be
A1 =sheet1!$G2
And B1 is

I using Excel 2003 and I have a worksheet that looks like this:
     Item Number Item Description       Qty Ship Ship $
    A VISION PRODUCTIONS
     FREIGHT FREIGHT    4 $107.67

I'm having trouble getting cell formulas to update when they reference
a saved workbook.
The situation I have has one workbook for each of 3 brands of hardwood
floors, and a fourth workbook listing trim and molding pieces to go

I have a spreadsheet with about eight columns.  Six contain numbers
about evenly divided between positive and negative numbers.  How would
I change all the positive numbers to negative and the negative numbers
to positive?

Is there a way you can make a external data source refresh if a function is
true.......
Ive got a few sheets which refresh automatically..... but i only want them
to refresh if a function is true.....