478 Answered Questions for the topic Microsoft Excel

Microsoft Excel Excel Ssrs Reporting Services

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
Microsoft Excel Excel Dictionary Routes

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
Microsoft Excel Excel Chapter 1

06/11/19

How do I enter a formula using semi-selection?
In cell C7, enter a formula using semi-selection to add cells C4, C5 , C6
Follows • 1
Expert Answers •1
Microsoft Excel

06/11/19

microsoft question
After making changes in the Assign Resources dialog box, you can verify the cost and work values in which of the following dialog boxes?A) Project Options: SchedulingB)WBS Code... more
Follows • 1
Expert Answers •1
Microsoft Excel

06/11/19

How can I create a regular expression for a column value, e.g., “Mumbai, India” or Nasik? Both values need to belong to the same column.
Follows • 1
Expert Answers •1
Microsoft Excel

06/11/19

How do I stop columns from overlapping when I use a secondary axis for a column chart in excel?
Follows • 1
Expert Answers •1
Microsoft Excel

06/11/19

Why is learning how to use Excel a good skill in the job market?
Follows • 1
Expert Answers •1
Microsoft Excel

06/10/19

How Do I automatically fill a column with days of the week in Microsoft excel?
Follows • 1
Expert Answers •1
Microsoft Excel

06/08/19

How do I arrange raw data in Google spreadsheet in group way?
Follows • 1
Expert Answers •1
Microsoft Excel

06/07/19

How do I Use Excel's Facebook Ad Manager to Change advertising Reporting?
Follows • 1
Expert Answers •1
Microsoft Excel

06/07/19

Why does a TEXT column of zero or unspecified length return a column of 255 bytes in Microsoft Excel? How does this work?
Follows • 2
Expert Answers •1
Microsoft Excel

06/07/19

How do I calculate N (-8/11) =0.23, where N is the cumulative normal function, on a calculator or Excel?
Follows • 1
Expert Answers •1
Microsoft Excel

06/07/19

How can I download/export YouTube playlist's description in Excel format?
Follows • 1
Expert Answers •1
Microsoft Excel Excel Ssrs Reporting Services

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
Microsoft Excel Excel Ssrs Reporting Services

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
Microsoft Excel

06/04/19

What is the equivalent of VBA for Google sheets, or do you use VBA there too?
Follows • 1
Expert Answers •1
Microsoft Excel

06/04/19

Why isn't Excel .xlsb format used more frequently?
Follows • 2
Expert Answers •1
Microsoft Excel Excel Ssrs Reporting Services

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
Microsoft Excel Excel Ssrs Reporting Services

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
Microsoft Excel Excel Export Hyperlink

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
Microsoft Excel Excel Ssrs Reporting Services

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
Microsoft Excel

06/02/19

How can I convert other spreadsheets into Google Sheets?
Follows • 1
Expert Answers •1
Microsoft Excel

06/01/19

What's the best plugin for removing duplicates on Google Sheets?
Follows • 1
Expert Answers •1
Microsoft Excel Excel

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
Microsoft Excel

05/30/19

What is the Excel GST invoice file and password to unprotect the sheet?
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.