Search Results

Search found 4393 results on 176 pages for 'excel addins'.

Page 12/176 | < Previous Page | 8 9 10 11 12 13 14 15 16 17 18 19  | Next Page >

• How can I make Excel documents open in different windows?

  - by Eugene

  Office 2007, Windows Server 2008 x64. How can I make Excel so that when I double-click a document, it opens in a new Excel instance, so that I can easily view them side-by-side as separate windows and not using the View-Arrange All functionality? Now I have to go to the task bar, click on one document to see it and then click on the other document…

  Read the article

• When opening any file in excel, a 1 is added to ther name, and the default is to save a new copy…

  - by Chris

  Ok... I've searched a lot for this, but it's not an easy question to search for! When I open any files (xls, or xlsx) in Excel 2007, excel acts like it's a read only file, essentially creating a new file with the name plus a 1 on the end... Eg. I open NewDoc.xlsx Excel opens it as NewDoc1.xlsx and the save button brings up the save as dialogue in…

  Read the article

• How can I speed up my macro in Excel 2003?

  - by user144872

  I have a macro that copies data from one cell to another and uses a VLOOKUP formula, among other things. My spreadsheet contains nearly 2000 rows. When I run it in Excel 2003, Excel starts to slow down as the macro processes rows 500 and above. It gets even worse when it reaches the 1000th row. It takes more than 5 hours to complete. In Excel…

  Read the article

• Excel workbook event order and usage when closing Excel

  - by mas_oz2k1

  Given the following workbook events: BeforeClose BeforeSave Please tell me: - The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving. - What happen if user cancels one of the saving operations say wb2? Note: Please provide link…

  Read the article

• Embed SWF into excel and change it flashvars when excel file is loaded

  - by Fraga

  Hi. I have a ShockwaveFlash embeded in excel. This SWF need 1 dynamic flashvar to run. I need to set it just before flash file is loaded, so flash can run without problems. Something like this. Private Sub Worksheet_Activate() ShockwaveFlash1.FlashVars = "DynamicData=123" ShockwaveFlash1.Play End Sub But it doesnt work. Ideas? …

  Read the article

• How to Highlight a Row in Excel Using Conditional Formatting

  - by Erez Zukerman

  Conditional formatting is an Excel feature you can use when you want to format cells based on their content. For example, you can have a cell turn red when it contains a number lower than 100. But how do you highlight an entire row? If you’ve never used Conditional Formatting before, you might want to look at Using Conditional Cell Formatting…

  Read the article

• Need advice for approach for a web-based app that loads excel worksheet but exposes only the charts

  - by John

  I'm looking for suggestions on the Visual Studio approach to take for a web application that is in the conceptual stage. My environment has a lot of tools: Windows Server 2008 R2 Standard 64bit Visual Studio 2010 Professional Edition Sharepoint 2010 Server Enterprise Edition SQL Server 2008 R2 Office 2010 Professional I know I will need…

  Read the article

• Create excel files with GemBox.Spreadsheet .NET component

  - by hajan

  Generating excel files from .NET code is not always a very easy task, especially if you need to make some formatting or you want to do something very specific that requires extra coding. I’ve recently tried the GemBox Spreadsheet and I would like to share my experience with you. First of all, you can install GemBox Spreadsheet library…

  Read the article

• Automating Excel 2010 using F#

  - by Clive Norman

  I have been searching for a FAQ to tell me how to open a Excel Workbook/Worksheet and also how to Save the File once I have finished. I notice that in most FAQ and all the books I have purchased on F# one is show how to create a new Workbook/Worksheet but is never shown how to either open or Save it. Being a newbie to F# I would very…

  Read the article

• Importing Excel spreadsheet data into existing Access DB

  - by Keeb13r

  I've designed an Access 2003 DB with 3 tables: APPLICATIONS, SERVERS, and INSTALLATIONS. Records in the APPLICATIONS and SERVERS tables are uniquely identified by a synthetic primary key (in Access, an "auto number"). The INSTALLATIONS table is essentially a mapping table between APPLICATIONS and SERVERS: it's a list of records of which…

  Read the article

• How do I convert all the cells of an excel sheet to text?

  - by Justin Tanner

  Given an existing Excel 2003 document with cells of any type (integers, text, decimal, etc), how do I convert the contents of every cell to text? And save all these changes in the same excel document?

  Read the article

• What the heck have I done to my Excel sheet (and how to undo it)??

  - by marc_s

  I have a lot of Excel sheets for all sorts of things - but none has ever acted up like this one here: This used to be a totally normal Excel 2007 sheet which I was able to resize, maximize etc. - but not anymore. What happened? What can I do to "undo" whatever I did to it. Any ideas?? I tried to share / undo sharing, I tried to…

  Read the article

• Excel 2007: plot data points not on an axis/ force linear x-incrementation without altering integrity of non-linear data

  - by Ennapode

  In Excel, how does one go about plotting points that don't have an x component that is an x-axis label? For example, in my graph, the x-components are derived from the cosine function and aren't linear, but Excel is displaying them as if .0016 to .0062 to .0135 is an equal incrementation. How would I change this so that the…

  Read the article

• Excel VBA combox box disable

  - by Chase

  Hi all, I am trying to enable/disable a combobox based on the value or state of a second combobox in Excel 2007. I think my code should look something like this: Sub DropDown266_Change() If DropDown266.Index = 2 Then DropDown267.Enabled = False End If End Sub However, I am getting a run time error '424'…

  Read the article

• Accessing .NET functionality from a macro in a VSTO Excel workbook

  - by Daniel DiPaolo

  A while back, I built an Excel workbook for someone else using VSTO SE, and there's functionality in the accompanying DLL that they'd like to be able to use in a VB macro in the workbook. Short of rebuilding the workbook with a control that does what they want, is there a way they can just hook into the necessary function…

  Read the article

• Column variables in Excel?

  - by Ryan

  Let's say I have column A and Column B. Cells in Column A contain either "Y" or "N". How can I set the value of the cell in the corresponding row in Column B with a formula that detects if the cell's value = "N"? Not new to programming logic but to Excel formulas, thanks for your help. -Ryan

  Read the article

• Create Excel document from a ContentType in SharePoint

  - by Saab

  Is it possible to create an Excel document using VSTO, using a SharePoint contenttype? Creating a document in VSTO based on a template is easy. Workbook newWorkbook = this.Application.Workbooks.Add(@"C:\temp\TestTemplate.xltx"); But the "template" that's assigned to a content type in SharePoint has xlsx as an…

  Read the article

• Excel 2003 - VBA for looping through every cell in a row to provide attributes/formatting

  - by Justin

  say I want to make the first row of the excel ss something like this: .Rows("1:1").Select With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic …

  Read the article

• excel formula to subtract number of days from a date

  - by oo

  is there a way in Excel to have a formula that does something like this: = 12/20/2010 - 180 which would take a certain date (12/20/2010 in this case) and subtract 180 days . .

  Read the article

• Excel MAXIF function or emulation?

  - by Andre Boos

  I have a moderately sized dataset in Excel from which I wish to extract the maximum value of the values in Column B, but those that correspond only to cells in Column A that satisfy certain criteria. The desired functionality is similar to that of SUMIF or COUNTIF, but neither of those return data that is…

  Read the article

• Consolidating Columns in Excel

  - by New to iPhone

  I have two columns in excel like the following a,apple a,bannana a,orange a,plum b,apple b,berry b,orange b,grapefruit c,melon c,berry c,kiwi I need to consolidate them like this on a different sheet a,apple,bannana,orange,plum b,apple,berry,orange,grapefruit c,melon,berry,kiwi Any help would…

  Read the article

• Excel formula question

  - by Josh

  I'm trying to convert an excel formula that I found to a more easily understood formula. Below is the formula I'm trying to interpret. What is ei?? =3*ei/2-27*ei^3/32

  Read the article

• Merge Mutliple Excel Workbooks

  - by IRHM

  I wonder whether someone may be able to help me please. I'm trying to use the code below to allow the user to select multiple Excel Workbooks, amalgamating the data into one 'Summary' sheet. Sub Merge() Dim DestWB As Workbook, WB As Workbook, WS As Worksheet, SourceSheet As String Set…

  Read the article

• Reading large excel file with PHP

  - by Itamar Bar-Lev

  I'm trying to read a 17MB excel file (2003) with PHPExcel1.7.3c, but it crushes already while loading the file, after exceeding the 120 seconds limit I have. Is there another library that can do it more efficiently? I have no need in styling, I only need it to support UTF8. Thanks for your help

  Read the article

• automatically execute an Excel macro on a cell change

  - by namin

  How can I automatically execute an Excel macro each time a value in a particular cell changes? Right now, my working code is: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("H5")) Is Nothing Then Macro End Sub where "H5" is the particular cell being monitored…

  Read the article

< Previous Page | 8 9 10 11 12 13 14 15 16 17 18 19  | Next Page >