Who is online?  0 guests and 0 members
Home  »  search results

Search Results: Excel 2007

38 results found
  • Remove the compatibility mode from excel files
    As you all know Excel 2007 has lot more features compared to Excel 2003. The extension with which the excel files are saved alos differs based on the version of excel. For excel 2003 the file is saved as .xls and for Excel 2007 the file is saved as .xlsx
    Author: indupriya indupriya     Date: 3/2/2012     Section: Blog
  • SSAS Calculation Formatting Not Showing in Excel 2007 or Excel 2010
    Occasionally in SQL Server 2005 and 2008 Analysis Services, you'll build a cacluation and set the formatting to be a value like a currency and are surprised that in Excel 2007 and 2010 the formatting does not carry over. The "randomness" of this actually
    Author: BrianKnight BrianKnight     Date: 10/1/2010     Section: Blog
  • Importing Excel 2007 data into SQL Server 2005
    I had a requirement to import an excel 2007 spreadsheet into a database as a table in sql server 2005. In Excel 2007 the drivers required for exporting have changed when compared to the previous versions. With Excel 2007 you use the driver named 'Microsof
    Author: indupriya indupriya     Date: 5/13/2010     Section: Blog
  • Copy Paste problem in excel 2007
    Today one of my colleagues was working in excel. He had a dataset that in one sheet which was filtered. He wanted to copy those records that were filtered into a new worksheet. But when he copied and pasted the cells into another sheet the cells that were
    Author: indupriya indupriya     Date: 11/1/2010     Section: Blog
  • Updating a single Excel cell using SSIS
    bsingha asked a question in the forums regarding how to update a single cell in one Excel sheet using the data from another sheet. So, I decided to post a quick blog post on how to accomplish this. First - make sure that SQL is installed and service packe
    Author: KeithHyer KeithHyer     Date: 1/16/2012     Section: Blog
  • OLAP PivotTable Extensions
    Wow, I am so excited that there is such a cool extension available for the excel 2007 onwards ,firstly I don’t know that we can use this cool features add-in extension within an excel .I have often used the PivotTable but I never try it for this particula
    Author: Anil Anil     Date: 3/10/2011     Section: Blog
    tags : Excel, MDx, PivotTable, SSAS
  • Excel Web Access error in Sharepoint 2007
    I wanted to use Excel Services on Sharepoint 2007 to migrate some of our BI reports from a third party application that we use. So I tried publishing to Excel Services from Excel 2007 assuming that our Sharepoint was setup to be used with Excel Services.
    Author: indupriya indupriya     Date: 2/16/2011     Section: Blog
  • Viewing Header / Footer Values in Excel after Exporting from SSRS
    Today’s question in my SSRS class warrants a blog. The question was: “Why can’t I see my text box that I placed in my footer of my report, when I export the report to Excel?” Well, after much research today I realized that it was a
    Author: SMcDonald SMcDonald     Date: 8/24/2011     Section: Blog
  • Print formulas from Excel
    Yesterday I had a requirement to compare formulas between two sheets. So I wanted to print the formulas and compare. This is a basic feature but I straight away did not know how to do it. So I started investigating the ribbon in Excel 2007. After about 2-
    Author: indupriya indupriya     Date: 1/31/2011     Section: Blog
  • BI Components of Office 2007 -- Part 1
    BI Components of Office 2007 We have built a datawarehouse in our sql server 2005 database and built some cubes in Sql server analysis services using sqlser server integration services. Now I wanted to utilise the BI capabilities of office 2007 to provide
    Author: indupriya indupriya     Date: 5/18/2010     Section: Blog
    tags : Excel 2007, SSAS
  • Add months to a date cell in Excel
    Yesterday I had this requirement to add number of months (m) to a cell that contains start date to estimate the end date. In 2003 I had to use a complex formula like below where A1 is the cell that contians the start date. =DATE(YEAR(A1),MONTH(A1)+m,DAY(A
    Author: indupriya indupriya     Date: 9/7/2011     Section: Blog
  • Breakup in SSRS 2005
    Hi, In SSRS 2005, the report produces nearly 80000 records. While attempting to save as excel a error is thrown and its common since excel(*.xls) can support only 70000 rows. Can anyone helpme out in sorting this issue or to save the report as excel 2007
    Author: lakksv lakksv     Date: 7/6/2011     Section: Forum
  • Problems with ReportBuilder Permissions
    Thanks Egan. We were actually looking at trying to use Report Builder 1.0 as the end-user tool for quick ad-hoc reporting needs because we didn't have Excel 2007. Our developers will all use the BI Intelligence suite, which is even more powerful than Repo
    Author: benagee benagee     Date: 12/22/2009     Section: Forum
  • Using Excel 2007 in SSIS 2005
    Many companies are not in a rush to upgrade their SQL Servers because of the enormous cost to upgrade. This results in the majority of companies still running previous versions of SQL Server (2005, 2000, and even earlier). Many times as the developer you
    Author: DevinKnight DevinKnight     Date: 3/2/2010     Section: Blog
    tags : SSIS
  • Loading Excel
    There is but Excel has a row limitation, unless you're planning on smashing all those rows across multiple tabs (worksheets). Here's link to limits: http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx . If you're
    Author: sqlchicken sqlchicken     Date: 9/21/2012     Section: Forum
    tags : PowerPivot
  • Client Tools
    Hi Ed, I would be interested in your experiences with Tableau. We've used Excel 2007 for the last 6 months in production and the feedback we've gotten so far is that our users like it because they are familiar with it. I would recommend looking at the fol
    Author: CurrentMember CurrentMember     Date: 12/28/2009     Section: Forum
  • Conditional formatting using multiple conditions - Excel 2007
    Today I had a requirement to colour code in Excel based on a few conditions. At first I thouhgt I could use thre to four rules in the conditional formatting to achieve this result but when I did that the results that I was getting was not very satisfactor
    Author: indupriya indupriya     Date: 3/4/2011     Section: Blog
  • SQL Server Data Mining with Excel 2007: The Aftermath
    I want to thank everyone for attending my session on data mining in Excel 2007. As promised here is the link to the website where you can download the database. http://baseball1.com/statistics/ It is available for download in 2 formats: 1. Access Database
    Author: TomLannen TomLannen     Date: 5/13/2011     Section: Blog
  • Show/Hide Office Ribbons
    Yesterday I was in a presentation and because we wanted to see most of the screen, there was a requirement to hide the top ribbon see the image below. I suggested to double click on the menu item to hide the ribbon. That is, double click either on Home, I
    Author: indupriya indupriya     Date: 11/24/2010     Section: Blog
  • Exposing Transactional Data to Excel Power Users
    Over the years of being a BI Consultant I have found that there are a lot of power users with excel and Excel is where they feel most comfortable. While Reporting services has made leaps and bounds over previous versions it still takes some extra effort t
    Author: MikeMollenhour MikeMollenhour     Date: 5/16/2010     Section: Blog
  • SQL Server 2012 Data Mining add-in for Excel 2010 Released
    Another release that went without much trumpeting was the SQL Server 2012 Data Mining add-in for Excel 2010. This has been a much awaited release for those vested in Data Mining. The current release was only available for Excel 2007 and if you tried to us
    Author: DevinKnight DevinKnight     Date: 3/7/2012     Section: Blog
    tags : Data Mining
  • Distinct Count in Excel
    Today I had to calculate the unique number of records in an excel spreadhseet. First I thought I could I achieve this by pivot table. But I could not do a distinct count. Here is the solution I found after some research. I copied the column for which I wa
    Author: indupriya indupriya     Date: 7/29/2010     Section: Blog
  • My takeaways from Adam Jorgensen's 24HOP session -- Zero to cube
    Here are my takeaways from today's fantastic session of Adam The first basic point was you can use "." instead of "localhost" to choose the localhost server. Defining the attribute relationship was very clearly explained that the relatiosnhps should be fr
    Author: indupriya indupriya     Date: 9/16/2010     Section: Blog
  • An other Example of Calculation-Dimension
    Recently one of my clients would like to see their Revenue figures represented some of the time as a positive (+VE) value and some time as a negative (-VE) value. They would like to have the ability to select between the two at run time in the Analyses Se
    Author: Qazafi Qazafi     Date: 8/31/2010     Section: Blog
  • Resizing Chart in Pivot Table
    Hi Everyone, I'm working in Excel 2007, sometimes the plot data section of charts doesn't auto-resize to avoid overlap from the legend. Is there a property in VBA that I can use to force it to auto-resize? Appreciate your help. Thanks, Pradeep
    Author: pkumar3 pkumar3     Date: 1/25/2011     Section: Blog