478 Answered Questions for the topic Microsoft Excel
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
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
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
05/27/19
Creating an ssrs report where upon exporting to excel the matrix is converted to a pivot table?
I was wondering when creating an ssrs report, is there a property or something for the matrix so that when the user exports the report a matrix in the report will be turned into a pivot table where...
more
Follows
•
1
Expert Answers
•1
![]()
Microsoft Excel
05/26/19
How can I send customized SMS (SMS already stored in an Excel file) to a number that is also stored in the same Excel file using my Android mobile phone?
SSRS and Excel color compatibility?
I have SSRS Reports created and rendering in Excel format. I used a custom color(mentioned in excel spec R23, G123, B87) in SSRS. But it shows a different color with the same combination in SSRS....
more
Follows
•
1
Expert Answers
•1
![]()
Microsoft Excel
05/25/19
How do I print tab / sheet name in Excel cell?
Follows
•
1
Expert Answers
•2
![]()
![]()
Microsoft Excel
05/25/19
What is the alternative to Microsoft Word, PowerPoint, Publisher, and Exel?
Follows
•
2
Expert Answers
•1
![]()
Microsoft Excel
05/23/19
Is it possible to link an Excel planner to a Google calendar?
Follows
•
1
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
![]()
Microsoft Excel
05/23/19
How do I combine rows from two files in Excel?
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
![]()
![]()
Microsoft Excel
05/23/19
What’s the most useful MS Excel trick you know?
Follows
•
1
Expert Answers
•2
![]()
![]()
Microsoft Excel
05/22/19
How can companies like Google offer natively opening and editing proprietary file types like e.g. Excel's XLSX or Word's DOCX? Do they pay Microsoft in that particular case?
Follows
•
1
Expert Answers
•1
![]()
Microsoft Excel
05/21/19
What type of encryption (if any) does Microsoft Word/Excel 365 use when I add a password to open?
Follows
•
1
Expert Answers
•1
![]()
Microsoft Excel
05/20/19
If my MacBook Pro restarts and I save one of my Excel files that says (AutoRecovered), where do I locate that file in my Finder?
Follows
•
1
Expert Answers
•1
![]()
Microsoft Excel
05/20/19
Should spreadsheet literacy be taught in k-12 education?
Follows
•
1
Expert Answers
•2
![]()
![]()
Microsoft Excel
05/20/19
How could I fetch live updating Excel data from other computers? I need to fetch that live data to another worksheet on another compter for data analysis under a homegroup network.
Follows
•
1
Expert Answers
•1
![]()
Alternatives to pulling data from ATOM Data Feed?
I did some extensive searching and was unable to find the answer to my question:
Are there alternatives to pulling data using ATOM Data Feeds other than Microsoft Powerpivot? I am trying to set up...
more
Follows
•
1
Expert Answers
•1
![]()
Microsoft Excel
05/19/19
What are some good excel or Google addins for that facilitate the creation of data charts?
Follows
•
1
Expert Answers
•1
![]()
Microsoft Excel
05/19/19
What formula or worksheet application would allow me to estimate how much sales is required to how a given number of employees?
Follows
•
1
Expert Answers
•1
![]()
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
![]()
Microsoft Excel
05/19/19
How can I trade in Excel, like placing buy or sell order?
Follows
•
2
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
![]()
05/11/19
ssrs exporting to excel as csv?
I am calling SSRS reports from an in house piece of software. All the reports made before me render as xlsx or xls and mine continuously are rendering as csv files which is messing up my...
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.
