194 Answered Questions for the topic Excel

05/13/20

help with excel

I can’t figure out how to make this happen. i have a user form created in excel. i have radio buttons, drop down lists and a text box on the userform. for example: if in the drop down list I choose... more
Follows • 1
Expert Answers •2
Excel

10/27/19

Can you help me with flash fill?
Follows • 0
Expert Answers •1

08/14/19

Help with analyzing Rank Data with Weighted Responses
I'm working in Excel on data related to hotels. Responses need to be weighted based the percent of total rooms in the sample. (E.g. Hotel A has 12 rooms, sample is 100 rooms spread over x hotels.... more
Follows • 1
Expert Answers •1

07/12/19

Deleting Two Columns Simultaneously?
The following code deletes Column J only: If Application.WorksheetFunction.Sum(Range("J:J").SpecialCells(xlCellTypeVisible)) _ =... more
Follows • 1
Expert Answers •1

06/14/19

Number field turned out as text in Excel, SSRS?
My SSRS reports one of the field is using this expression, where the field is a number field. I want to see blank field is the value is `0`. =IIf(Fields!PERIOD02_VALUE.Value <>... more
Follows • 1
Expert Answers •1

06/13/19

Find Excel three-columns match in two different sheets?
I've three sheets from differents periods of several companies It happens that not same accounts were used on all periods. I need to compare two or three companies from two different periods. I've... more
Follows • 2
Expert Answers •1

06/12/19

SSRS report - conditional reporting after exporting to excel?
I have built a SSRS report where I have left the first column of a table empty. I want every cell in this column to be conditionally formatted so that it changes to red fill whenever I type in "r"... more
Follows • 1
Expert Answers •1

06/12/19

SSRS Issue with values that are text and number exporting into excel?
I am having an issue where I have similar hyphenated values 1304-4(text) and 1306 (number) The main issue I am trying to overcome, is when I export my SSRS report (.rdl) to excel, I get an error in... more
Follows • 1
Expert Answers •1

06/12/19

Column widths changing when exporting from SSRS to Excel?
I have a simple SSRS report which contains a single table with a header row, footer row and any number of detail rows. The width of the report and table is 7 inches and the report has .5 inch... more
Follows • 1
Expert Answers •1

06/12/19

Creating Excel reports with Hyperlinks to other Excel worksheets via SSRS 2016?
I need to create excel reports with SSRS 2016. These reports have need to have a `sheet 1` that is an index to the other sheets. I can get the excel function inserted correctly using an expression.... more
Follows • 1
Expert Answers •1

06/11/19

SSRS and maps of route from data?
I have data that has the longitude and latitude values for a point of origin, stops and the return point of origin. I'd like to be able to create a matrix that uses this information from an Excel... more
Follows • 1
Expert Answers •1

06/07/19

SSRS Large Report -- Error When Exporting to Excel?
We are having an issue when exporting a large SSRS report to Excel. We receive the following error when it is run over a three-year date range. If the report is run for each of the years... more
Follows • 1
Expert Answers •1

06/05/19

How to Lock cells in SSRS while exporting to Excel?
I have a report in SSRS 2008. I need to export it to excel and lock some columns and rows. For example I have 10 columns and 500 rows in excel. 1- I want first two column can't be edited. Other... more
Follows • 1
Expert Answers •1

06/04/19

Column headers not repeating on each excel sheet in SSRS?
I have a SSRS report which has a row grouping of order number. My stored procedure returns a data for a week, month and year depending on the end date. So as a result I wanted three excel sheets... more
Follows • 1
Expert Answers •1

06/04/19

SSAS cube permissions exclude excel?
following problem: I have a cube and the customer just wants to allow read access via a ssrs report and not through excel. Is it possible to change the permission that specific roles are only... more
Follows • 2
Expert Answers •1

06/04/19

ssrs report export to excel - broken hyperlinks?
I have large report and each row contains hyperlink. Report containing 50k or more rows is exported to excel. After export I try to open xlsx file and get message telling me that file contains... more
Follows • 1
Expert Answers •1

06/03/19

Connecting Excel 2013 to SSRS 2012 to use as a datasource?
I am trying to set up a Data Source using an Excel 2013 file for the information to feed a report. Here are the steps I'm following: 1. Click on Data Source 2. Add new Data Source 3. Change Type... more
Follows • 2
Expert Answers •1

05/31/19

Create an excel spreadsheet that gets quotes for each quantity and each markup on cost at each quantity.
Campus Manager needs a quote for a product. Here are our inputs: Shirt Cost: $12 per shirt Print Cost: $14 per shirt Set Up Cost For Order: $20 flat cost Shipping Cost: $1 per shirt Sales Manager... more
Follows • 1
Expert Answers •1

05/28/19

Setting up a tabbed report that exports to Excel from SSRS?
I have a report that needs to be exported from Web Reports/SSRS to Excel while generating a tabular structure that includes a 'Summary' tab with all the information, which also includes a 'Total... more
Follows • 2
Expert Answers •1

05/27/19

How to export SSRS report (.rdl) directly to PDF with OfficeWriter?
I want to export a SSRS 2008 R2 (.rdl) report directly to PDF, how can i do this with OfficeWriter? I have gone through SoftArtisans documentation, i couldn't find a way out there. We can export an... more
Follows • 1
Expert Answers •1

05/27/19

ssrs export to excel slow perfomance?
Good day. I have a report wich consist of several textboxes and a tablix with row grouping. I have another two tablixes inside that group(perhaps I should merge them, since they consume the same... more
Follows • 2
Expert Answers •1

05/23/19

tsql to export and attach SSRS report to email?
I don't think there's an easy way to do this, but here goes. We have an `SSRS` report that can be invoked with `http://MyServer/ReportServer/Pages/ReportViewer.aspx?%2fSales%2fSalesReport` We... more
Follows • 1
Expert Answers •1

05/23/19

Excel formula that multiplies the value of a cell times 2 only if it is under $.99?
Hello and thank you for your help! I am writing a formula to help me calculate coupon deals for my shopping trip. My store doubles coupons $.99 or under, so I need a formula that does the... more
Follows • 1
Expert Answers •2

05/19/19

Excel VBA Code to pull SSRS data as a dataset?
I can’t seem to find a solution for my problem no matter how much I Google. (Please excuse my verbosity in the following explanation) My process is that I have to go to the SSRS web page, run my... more
Follows • 1
Expert Answers •1

05/13/19

Excel as a data source in SSRS Query a Specific Column of a Sheet?
I want to query the data from an excel file utilizing ODBC System DSN for Excel 12.0. What will be the right syntax to query specific columns from a worksheet and not the whole worksheet like... more
Follows • 1
Expert Answers •1

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.