Table relationships in Excel?
I have an excel file exported from SQL server. There are two tables
1. User (columns: id, name, address, etc)
2. Tasks (columns: id, userid, description)
Is there a way to display the user NAME insead of the ID in the tasks table?
Many thanks in advance! Saturnius
You could do a vlookup on the linked field. If id is the same in both tables
use a vlookup function
> I have an excel file exported from SQL server. There are two tables
> 1. User (columns: id, name, address, etc)
> 2. Tasks (columns: id, userid, description)
> Is...Pulling data daily from a differently named report everyday
I have a spreadsheet where I use formulas to pull data from multiple
reports on a shared server everyday. What I do is to save those
reports under a certain name everyday since the formulas have to have
the static report name in them to pull data. (For example, A1 may pull
data from c:\reportfolder\reportA, B1 may pull from c:
\reportfolder2\reportB, etc). In these report folders our IT group
runs a new report in it everyday but of course they change the name of
the report every day (to reflect the date) . . so in the reportfolder
there will be "reportA-3-12-2009", and "...enlarge validation drop down box excel 2000
I use validation drop down dialogue boxes in Excel 2000 to fill in purchase
orders from an existing list of products. This works fine for the most part
but I have a few questions. I have close to 1000 products on my list. When I
use the drop down box to fill in my forms, the box is too small or too
sensitive. With the list being that long, the data displayed in the box tends
to jump around when I scroll, page up or page down. I feel that if the box
could be made longer, the data would be more stable and easier to access. Is
It appears to me that my validation list is on...Hotmail: Can't Send/Receive 1 of 3 Accounts (using XP)
I'm using Outlook XP, and I have 3 Hotmail accounts. 2 of them I've been
using for a long time without any problems. However, with the 3rd one I
just added now, Outlook stalls for about a minute before spitting out:
A connection to the server could not be established.
http://services.msn.com/svcs/hotmail/httpmail.asp is now in offline mode.
There may be server or network problems or your timeout interval may be too
Please search Microsoft Outlook Help for [HTTP Mail troubleshooting]
That's the message when I just add the account to the list of accounts.
When I...Excell graphs
I would like to make a grafh with excell but seem to be very lost.
:confused: I would like the graph to go horisontal left to right
Like a time-line.
Thanks for any tips
dammit1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16311
View this thread: http://www.excelforum.com/showthread.php?threadid=278285
By 'time-line', do you mean a gantt chart?
http://peltiertech...Excel slow to epen with Network Connection
Excel 2003 has recently become very slow to open. Regardless of the
workbook / file. I have disabled all Add-In's and cleaned out the
folder. The slow down appears to be related to having a live
internet connection. If I disable my connection or pull out my
cable and launch Excel it opens straight away, if I plug it back in
re-enable it it takes 30-45 seconds to open. I have added Excel to
Windows Firewall exception list but it still takes around 15-25
open a workbook.
Any ideas what its doing? I have read somewhere online about it
bef...Converting Outlook XP .pst to Outlook 2007 format
I installed Office 2007 over my existing Office XP. I prefer to keep my .pst
file in a location that is easily found, I keep it in C:\1data\Outlook. When
I try to convert it to the new format it tells me the file is in use, of
course it is in use, I have to have Outlook open to convert. How do I get
around that? I still wish to keep it in the same location as my two backup
programmes, Outlook backup and Datakeeper backup, are pointed there. Thank
How are you trying to convert it?
Diane Poremsky [MVP - Outlook]
Author, Teac...How to programme this in excel?
This is what I want to know..
cell B1 & C1 is the cell to enter the duties of two staffs (namely X & Y).
B1 is for staff X, C1 is for staff Y. staff can chose any one of duty in B1
& C1 frm a dropdownlist of 10 different duties(like "Break shift", "10 - 6
PM", "10 - 2 PM"..and so on)..
We have another cell D1 E1 & F1 where we enter the staff strength in the
shop on three intervals of time (say 10 - 2PM, 2 - 6PM, & 6 - 10PM)
Assume D1 cell to show the staffs present in the shop during time interval
10 - 2PM, E1 for 2 - 6PM & F...change excel pointer
Hiw can I change the colour of the white excel mouse pointer?
Not an Excel question since changing the mouse pointer applies to all apps.
Use Start|Control Panel->Mouse; open Pointers tab and make a selection.
I hope no one else uses the computer!
Bernard V Liengme
remove caps from email
"sarahc" <firstname.lastname@example.org> wrote in message
> Hiw can I change the colour of the white excel mouse pointer?
I'm using a different color mouse pointer...Different margins on different pages
I am setting up a template for letters at work. The first page of our
letterhead has one ste of margins and all subsequent pages will have a
different sent of margins.
I know that section breaks can be used, but if staff copy and paste text
from existing letters into this new template, the section break moves.
Is there any way of locking the section break to the page? so the pasted
text goes over the top of it?
You could setup your document with a 'different first page' layout. That allows the first page to have a different set of margins to
the rest o...Excel 2007: No screen refresh
I have a network which around 30 Windows XP pcs, incl. Office 2007
Pro. All updates are installed. Under some circumstance, Excel 2007
will not refresh the screen, for example when Excel was minimized and
will maximized. I saw this problem not on all pcs but on some. I did
also update the graphic card driver and on one pc I changed also the
graphic card. Do you know this problem? Is there a workaround?
...Different values for error bars in series
In Excel 2007, how do you put in different error bar values for each data
point in a series? So far I am only able to put in one value for all in my
See Jon's blog on the subject.
On 06/04/2010 15:52, wdwind1 wrote:
> In Excel 2007, how do you put in different error bar values for each data
> point in a series? So far I am only able to put in one value for all in my
> bar chart.
Andy Pope, Microsoft MVP - Excel
...Using banner paper Publisher 2002
Can you use banner paper in Publisher 2002? I am fairly
new to the app and I have searched high and low and can't
seem to figure out if I can use it and if so how? Any
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Tracy Buthe <email@example.com>...
> Can you use banner paper in Publisher 2002? I am fairly
> new to the app and I have searched high and low and can't
> seem to figure out if I can use it and if so how?
What size banner paper are you using?
Ed Bennett - MVP Microsoft Publisher
http://www.mvp...Excel Database #2
I have been doing my invoices in Excel from Office 2000 and storing the
relevent bits into a database created by the template wizard in the Data
drop-down. Now I have office XP on my new machine but this option does not
appear in Excel, How can i create an invoice template that stores to a
...MS Excel help needed for newbie
I'm by no means a programmer. I'm trying to knock together a (what
should be) simple spreadsheet in Microsoft Excel for a calculation I
have to do on a regular basis. I'm hoping that some kind people within
this group will be able to help me with some formulas and questions.
If anyone is able to help me could you please contact me at
On Oct 5, 7:57=A0am, Dean Brown <bramfiel...@googlemail.com> wrote:
> Hi group.
> I'm by no means a programmer. I'm trying to knock together a (what
> should be) simple ...Windows 7 Upgrade from XP Pro IE 8 Certificate Errors
My PC was recently upgraded from XP Pro to Windows 7 Pro. I had IE 8 before
on XP, but now I am getting certificate errors for many of the sites that I
regularly visit including our companies own intranet site, google mail,
several financial institutions websites, etc. I know these sites are safe,
but I cannot figure out what the upgrade process has done to my system to
cause me to get these certificate errors. I have spent much time googling,
and tried many different IE setttings, double checked the date time setting
on my machine etc. all to no avail. PLEASE HELP!!! Below ...Can't save Excel using Save button,
When I try to save an Excel spreadsheet, I get a message saying "GWXL97.xla
could not be found. Check spelling of file name and verify that the file
location is correct." I have never named any of files by that name and don't
know what it refers to. I have to hit the "X" button on the upper right hand
corner and wait for it to ask me if I want to save it, then go through the
save process. This happens even if I try to save changes to an existing excel
This may help...
xl: close button is dimmed after groupwise is installed
http://support.microsoft.com...A Different CRM for GP
We are pondering the idea of implementing MS Dynamics CRM. However, I am
curious whether anyone else has had success in integrating a different CRM
product with GP 10.0. It's not that we don't like the MS product; I just
like to ensure I have covered all bases.
Our partner does not have any other recommendations as they have not worked
with any other CRM applications.
Any information would be greatly apprecaited.
GoldMine is a good product, very mature, and easier to maintain table
structures. There are links to GP but I cannot remember the fir...Unable to open embedded word document from Excel
I have Excel 2003 (SP3) installed on my computer. In an Excel file, I
inserted a word object (created from file, display as icon) and the insertion
When I try to open my word document from Excel, nothing happens. No error
message and the file doesn't open. It is like if my file icon is simply a
When I open the same Excel file with another computer(Excel 2003), I can
open my word embedded object easily.
In fact, I can insert Excel or txt object in Word document without any
problem but everything I insert in Excel doesn't work (word, txt, et...How to add a description to an excel table
how can I add a decription to an excel table?
I want to set a name and a description of a table content. So I know, what
data is contained in a table. My workspace contains more than one table.
Click on any cell in your table(s). Then Insert > Comment
> how can I add a decription to an excel table?
> I want to set a name and a description of a table content. So I know, what
> data is contained in a table. My workspace contains more than one table.
..."Excel needs to close"
Frequently, when turning my computer on, I will get the error message,
"Microsoft Excel for Windows has encountered a problem and needs to close".
It has not been left on nor was it used in the previous session of computer
use. I am using XP Home. How can I fix it or should I even be concerned?
Check to see what is starting up when you boot your computer up. See if
anything is in teh startup folder, check using msconfig as well
"Ed Mullikin" <firstname.lastname@example.org> wrote in message
> Frequently, when turning my comp...Copying spinners for each cell in Excel 2003?
I have an inventory tracking sheet that keeps track of my inventory.
I've added in a spinner control to increase/decrease a value in a
certain cell. In my worksheet, the value is located in column E, and
the spinner control is in column F. I have about 200 spinners to add,
and need to fill down the links to it's adjacent cell. I found
something related to checkboxes, but how do I adapt it for the spinner
control? The first value is in E3, and the first spinner is in F3.
Create 200 spiners in F3:F203 and link to E3:E203
Dim myRng As Range
Dim Spnr...character spacing Excel 2003
How does one get all numbers in a column to have set spacing instead
of proportional spacing? I remember setting proportional or fixed
back in the days of DOS, and haven't used it since and I'm unable to
find it in Microsofts online help for either Excel or Word (2003).
Try using a fixed width font like Courier or Courier New.
Microsoft Excel MVP
"Joe" <JOsterheim@gmail.com> wrote in message
> How does one get all numbers in a column to have set spacing instead
> of proportional spacing? I remember...2 users access calendar online with different rights
user A wants to give user B permission to see, add and edit entries in
user B is able to see, but not to add or edit entries at the moment
in outlook itself its working. user B can open the folder calendar of user A
and make entries and change entries
what have to be done that this is possible also with web access exchange ?
On Thu, 26 Oct 2006 14:09:29 +0200, "Mike Schwarz" <email@example.com>
>user A wants to give user B permission to see, add and edit entries in
&...Same column, different cell width at different row
I have tried inserting a break and split, didn't work. I just want to
separate the top half of a page with the bottom half so I can apply different
cell width on the same column. Or how would I be able to do this? Same
column but different cell width.
You can't do that.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Glenn Chung" <GlennChung@discussions.microsoft.com> wrote in
>I have tried inserting a break and split, di...