Search Results

Search found 14082 results on 564 pages for 'vsts 2010'.

Page 165/564 | < Previous Page | 161 162 163 164 165 166 167 168 169 170 171 172  | Next Page >

• Is it possible to use images in an Excel IF statement?

  - by dunc

  Quite a simple one here, but I guess the answer will be a resounding no! I have a few symbols, basic clip-art, which I'd like to display depending on certain information. At the moment, I'm using this statement to display Y or N: =IF(B2>0,VLOOKUP(B2,'Student Data'!$A$2:$L$36,8),"") It's a simple lookup which checks another worksheet to see if someone has entered "Y" or "N" into the relevant column. What I'm wondering is this: would it be possible to display these clip-art images (I have them in .PNG format) instead of simple text? I.e. IF VALUE_OF_CELL=7, DISPLAY IMAGE1. Thanks in advance,

  Read the article

• Can I control Caption sequence numbering from styles other than "Heading "?

  - by Carl Witthoft

  Similar question to Wrong caption using 'Appendix' header style , so the answer may well be "I can't." I created a style called "Appendix" which is based on "Heading 1" , is at "level 1" , and is numbered A,B,C... . I use the standard "Insert Caption" to get Figure or Table captions. I then modded the first field code to be STYLEREF "Appendix" \s and that properly displays the Appendix letter sequence. However, the second field code, SEQ \s 1 refers to the last "Heading 1" . I've tried things like SEQ \s "Appendix" to no avail. Is there any way around this? Should I generate a new "Appendix caption"-ish style which is a "numbered list" and manually set the 'restart at 1' counting in each Appendix?

  Read the article

• Exchange ActiveSync is not working with Android's 'verify certificate' setting, what do I need to do to make them work together?

  - by Yannone

  All other methods of Activesync and web access to my Exchange server are working fine with no errors or issues, but when we attempt to configure Android phones for the server, it will only work with 'verify certificate' checked off. Ideally, I'd like my users to be able to use the default configuration, which includes the 'Verify Certificate' option. My primary question is: 'What does Verify Certificate do?', as I imagine if I knew that, I might have some idea why it isn't working.

  Read the article

• How to get cells to default to zero or calculate additonal fees, based on selection from a drop-down list

  - by User300479

  I am building a Pay Rate Calculator worksheet with a Flat/Base pay rate & numerous Overtime pay rates. I would like to be able to have the "Overtime" pay rate cells to change depending on my selection from my drop-down list. My list selections are "Flat Rate" and "Compounding". 1) If I select "Flat Rate" how can I make all the "Overtime" cell rates and totals default to zero or calculate to zero, to show the user there is no overtime rates to be applied to this job and to use the one rate to pay? 2)And if I select "Compounding" the Overtime rate cells are updated to add/include additional fees, to show the user Overtime rates apply to the job and penalties have automatically been calculated on top for them. Please explain like I'm a 2 year old - learning as I go. Many thanks :)

  Read the article

• Printing data in Excel ver 14.0 in a maxed cell

  - by Zppy

  I have set the cell to the maximum size (column width of 255 and row height of 409.5). In order to view all of the data in the cell, I have to use up/down arrows. I don't need to necessarily view all of the data in the cell at one time, however I do need it to print, and it's only printing what's viewable (not what you can scroll through).....any suggestions on how to get the entire cell to print? Thanks!

  Read the article

• Exchange Not Delivering Email

  - by wolfvilleian

  I'm having an issue where my Exchange Edge Transport server receives mail (found in logs) and then it vanishes, never ending up in the users mailbox, I have a edge subscription setup between it and the main Exchange server, how can I go about tracing the message to figure out what is broken? I also have found records of the message in the logs on the main Exchange server. Thanks a ton for any help Edit: If I change port 25 on my main router to point to the main exchange server as opposed to the Edge Transport, email comes through fine form external domains and delivered in the correct mailbox

  Read the article

• How to make a dropdown list such that... (see details)

  - by daysandtimes

  I want to plot the stock prices of certain companies VS the S&P500. I have all the price data downloaded in my excel sheet already. I want to create a line graph in Excel. One line is fixed and that would be the S&P500, and the other would be the company I select. I know how to use data validation to create a dropdown list, but how could I make it in such a way that when I select company A, I would only see company A's price data but not company B, C, etc. Then when I select company B, I would only see company B's price data & the S&P price data. And so on. The S&P line will be visible all the time, but the various company's price line will only appear if it is selected. Is there any easy way to normalize all sets of data in a way such that the starting point is always 100?

  Read the article

• How to combine data from two rows, when certain criteria is met

  - by Corde Parker

  I'm trying to make this Excel document but I want the AdminTimes for the same LastRxNo to be on the same line. So if the LastRxNo is the same, have one line and the AdminTime column will have multiple values. Here is a picture of what I want it to look like Any ideas? I was thinking an IF function, but I'm not too familiar with Excel to get it to work. It was just made in the Microsoft Query tool in Excel.

  Read the article

• MSWord table shading prints too dark

  - by Relaxed1

  My friend has a very light shading in his MSWord tables. However they still print too dark to read the text. When emailed to a colleague using the same printer, it prints light nicely. However they cannot find any setting that is different between them. Any ideas? Thanks! (P.s. for myself this would help for non-tables also, when 'highlighting' text. I do know that 'shading' gives more colour options for non-tables, but it would be nice to know anyway. Thanks)

  Read the article

• What is the best way to migrate to a new file share in a new domain?

  - by cbattlegear

  I am looking to move a file share (100 GB or so) from one domain/server to a new domain and server. I would like to do this with little to no downtime and if possible I would like to be able to map permissions from the groups/users in the current system to groups/users in the new domain. A side question, a large number of the files in the system are office documents with hard links to the old file server. Any way to programmatically change all those links to the new file server?

  Read the article

• Is there a way to prevent a message from accidentally being sent?

  - by dan

  I am terrified of accidentally sending a reply before I'm finished editing it. Usually what I do is either: copy the email into word, edit in word, then hit reply-to-all in outlook, paste in my text, and send. hit reply-to-all, delete the recipient names, edit, add the recipient names, and send. Is there a way to 'lock' the email so I can't send it while I'm making edits in Outlook? I hate having to switch between programs just so I can edit.

  Read the article

• Exchange stops working after changing System Time

  - by L.M

  I am currently in a situation where the system time of my windows machine differs 6 hours from the actual local time. I tried chaning the system time of my windows machine 6 hours back to match the actual local time. The issue is, when the system time is changed, Exchange stops working as it wont start anymore. When i change the time back Exchange works again. Here is the error that it shows when im trying to open the management console after changing the system time. The Follwing error occured while attempting to connect to the specified server "servername". The attempt to connect to http://servername/PowerShell using "Kerberos" authentication failed: Connecting to remote server failed with the following error message: Access is denied. For more information, see the about_remote_troubleshooting Help topic. Any Solutions to this problem?

  Read the article

• How to add quotes in visual basic? [on hold]

  - by Poistenec

  I'd like to ask how is it possible to add quotes in VB. I'm trying to run command which contains quotes.. example: Shell("cmd.exe") SendKeys.Send("cd "c:\users\abc def" ") <<<<--- this line SendKeys.Send("{ENTER}") there is an syntax error. the problem is that I need to add quotes to some commands as there is a space in folderpath. As a beginner in VB I'm not really sure how to describe the poblem correctly so I hope you can see the it in my example :/ Thank you all in advance

  Read the article

• Can I filter multiple column headers to display subheadings of each in Excel?

  - by Gigi

  I can't seem to find this anywhere... it may not even be possible without coding? I have a spreadsheet containing more than one heading in a single column. These headings are identified with blue background and white font. Each of these headings have items listed below them. These "subheadings" are smaller, auto-black font and no fill background. Currently I have to scroll down the spreadsheet to view all headers and their contents. How do I create a filter that would allow me to sort on whichever header I want, so that (only) the contents of that particular header are displayed?

  Read the article

• Hide/Unhide rows based on more than one cell value

  - by Mike

  Please help me I am using the following code to hide rows if cell values are 0: Private Sub Worksheet_Calculate() Dim LastRow As Long, c As Range Application.EnableEvents = False LastRow = Cells(Cells.Rows.Count, "I").End(xlUp).Row On Error Resume Next For Each c In Range("I9:I48") If c.Value = 0 Then c.EntireRow.Hidden = True ElseIf c.Value > 0 Then c.EntireRow.Hidden = False End If Next On Error GoTo 0 Application.EnableEvents = True End Sub It works perfectly, but I would like for the code to also check column K (the same range K9:K48) if both cells in a row are 0 then the row must be hidden. How can I change the code to do this?

  Read the article

• 24 hour day - having trouble with 20:30pm to 01:00am

  - by Tom

  I'm having problems figuring hours worked, with a 24 hour day formula that accounts for swing and graveyard this is a 4 column layout - example below (I only need to figure totals hours worked minus Lunch) example: in 20:30 out (lunch) 01:00 in(lunch) 01:30 end of shift 06:30 Answer should be: should be 4.5+5 = 9.5 hours worked However I'm having trouble with 20:30pm to 01:00am value thank you in advance!

  Read the article

• Fill rows down quickly (column or matrix of zeros)

  - by Mark Miller

  I have an extremely basic question, but I have never found the answer by searching the internet. I simply want to create a large column of zeros with Excel. Sometimes I want to create a huge matrix of zeros (maybe 600 rows by 500 columns) and then replace a few zeros with 1's to create a model design matrix. I have always started by creating a column of, for example, 10 zeros, copying and pasting those zeroes, then copying and pasting the resulting column of 20 zeros, etc., until I had the desired number of rows. Then I would copy and paste that column of zeros one at a time over and over until I had the desired number of columns. This procedure is tedious and time-consuming and I know there must be an easier way. Do you know of any other methods?

  Read the article

• How to lookup a value in a table with multiple criteria

  - by php-b-grader

  I have a data sheet with multiple values in multiple columns. I have a qty and a current price which when multiplied out gives me the current revenue (CurRev). I want to use this lookup table to give me the new revenue (NewRev) from the new price but can't figure out how to do multiple ifs in a lookup. What I want is to build a new column that checks the "Product", "Tier" and "Location/State" and gives me the new price from the lookup table (above) and then multiply that by the qty. e.g. Data > Product, Tier, Location, Qty, CurRev, NewRev > Product1, Tier1, VIC, 2, $1000.00, $6000 (2 x $3000) > Product2, Tier3, NSW, 1, $100.00, $200 (1 x $200) > Product1, Tier3, SA, 5, $250.00, $750 (5 x $150) > Product3, Tier1, ACT, 5, $100.00, $500(5 x $100) > Product2, Tier3, QLD, 2, $150.00, $240 (2 x $240) Worst case, if I just get the new rate I can create another column

  Read the article

• Highlight column when a row is clicked, depending on condition

  - by Fredrik

  We have a large matrix with lists of servers on the rows and persons as columns. Then we mark the column/row with an X if the person has access to the server. Pretty basic. But as the matrix grows, it becomes more difficult to quickly find the right person with access. So I'd like some way to make it easier to use In the example above I have clicked on the row "Resource B" and would like all the columns where there is an "X" (User 1, User 2) to be highlighted somehow. Then if I click the row for "Resource C", "User 1" should be highlighted.

  Read the article

• OS won't boot during vs2010 install on vista 64

  - by Noam

  I am installing vs2010 on a vista 64bit machine. During the install it asked for a restart. Since that, vista won't load. I tried restore to previous good config - didn't help. I am only able to boot it using safe mode with networking. When I did that, it continued the vista part of the install (the screen with the 3 out of 3 updates) but after that when I restarted again - still fails. HELP!!!

  Read the article

• Automatic Reply Out of Hours

  - by Inbr3d

  Is there a way i can use a rule or "timer" of some sort to turn on out of office, or enable an auto reply for 1 mailbox (Sales mailbox) within a time period. Reason: We deal with all timezones, we only open 6am-8pm. critical sales are sometimes lost the automatic reply will involve a telephone number for emergency sales. (yes, spam i know) I wish the auto reply to come from "[email protected]" if this is possible. I've lokekd at transport rules, cant see anything. I cant word my question well enough for google to give an answer.

  Read the article

• Can I insert rows next to a locked column in Excel?

  - by Tom

  If I lock cells A1:A3000, is there a way to insert rows in columns B-Z? I highlight them and I don't get the option to insert even though it is selected in the lock options. (Bottom line is that I need column A static, not to move.) Any ideas? Is it even possible? Better yet, is there any way to have formulas in column A static, as I insert rows in column B? Column A formulas change cell location when I do so.

  Read the article

• How to create a Service Connection Point for Exchange (Manually)

  - by Ionoxx

  I'm being cautious here. Before I remove anything I want to be able to put it back. I'm having issues with a domain joined computer that is using SCP to get exchange autodiscovery information. It's getting information for the now unused internal Exchange through SCP even through the profile is using Office 365 on another domain. According to this conversation, I can simply remove the object from Active Directory Sites and Services. I want to know how to add back in should this create more problems, or if we reinstate the Exchange server. Right clicking on the parent "autodiscover" node doesn't allow me to create a Service Connection Point. Will simply running the cmdlet "Set-ClientAccessServer -identity servername -AutodiscoverServiceInternalUri url" be enough to recreate the object? Thank you!

  Read the article

• How do I force an exchange database to become "active"?

  - by makerofthings7

  We had a catastrophic failure where all that remains is a single edb file. No backups. No log files. The database that remains is on the "passive" copy. The "active" copy is missing, but the server is active. The Exchange console reports that the edb file needs to be reseeded, however there is no source to reseed from. How do I make the "invalid" database file (missing logs) valid? How do I make exchange recognize this as a valid database to use as a primary?

  Read the article

• Formula to format a cell to subtract one decimal place from another cell and have the calculated results displayed

  - by user242618

  I have a value in one cell that has four decimal places, in the cell below, I have the metric conversion formula. I want the cell below, with the metric conversion formula to display one less decimal place than the cell above. For example, if the English measurement is .#### (4 decimal places), I need the conversion cell to display .### (3 decimal places) and if the English measurement is .### (3 decimal places), I need the conversion cell to display .### ( decimal places), and so on. How can I do this?

  Read the article

< Previous Page | 161 162 163 164 165 166 167 168 169 170 171 172  | Next Page >