-
Microsoft Excel: Interpret CSV URLs as hyperlinks
I have a CSV file and I'm wondering if it is possible to have Microsoft Excel interpret my URLs as hyperlinks. Can anyone help me? Thank you.
Last updated: -
How to convert Microsoft Excel spreadsheet to CSV programmatically
Does anyone know of an easy way (possibly a Unix script or command) to convert my Microsoft Excel spreadsheet to CSV? Thank you very much!
Last updated: -
Microsoft Excel PivotTable not updating month columns
Hi there, My Pivot table is not updating to a new month column (October) after I updated the source data with updated info for October and changed data source to include the new data elements. I know it should automatically include the new month as a new column in the table, but for some reason its...
Last updated: -
Save Microsoft Excel sheets to separate CSV files
Is there a way for me save each Microsoft Excel sheet in my workbook to separate CSV files with a macro? I know Excel won't let me save all the sheets to different CSV files so I thought there might be another way. Thanks.
Last updated: -
How do I add an additional Fiscal Year to my Microsoft Excel pivot table?
I have a Pivot Table in Excel that is already set to display Fiscal Year, Fiscal Quarter and Dates. What I need to know is how do I add an additional Fiscal year to the list of years available. It goes from 2010 through 2016, but I need to add data for 2017 now.
Last updated: -
Upload image from Excel sheet into MySQL
How can I upload image from my Excel sheet to MySQL Database?
Last updated: -
Excel 2010: Print area function doubles up
The print area function now doubles up and I have to tap it twice to clear it, is this because of edge. What should I do?
Last updated: -
Microsoft Word and Excel documents open very slowly
In Microsoft Office 2007, when I'm trying to open documents in Word and Excel - it's very slow. What should I do?
Last updated: -
How to export HTML table to Microsoft Excel in JavaScript / Firefox
I need to export my dynamic HTML table to Microsoft Excel using JavaScript. Is there a way to do it in Firefox browser? I don't want to use ActiveX too.
Last updated: -
Read ODS document on Microsoft Excel
How can I read an ODS document on Microsoft Excel? Thanks so much.
Last updated: -
How to export Google Chrome data to Microsoft Excel
I did a bunch of data analysis in Google Chrome and I need to export that data to Microsoft Excel. Can I use the Chrome Developer Tool to do this? I also want to do a bulk export (not one at a time). Thanks.
Last updated: -
How to create an XML file from Excel
What are the steps to be followed when converting an Excel file to XML file?
Last updated: -
Sending a file to Excel spreadsheet
I need to send a file that has an item name field that contains commas and double quotes to an Excel spreadsheet. I need to keep the commas and quotes in the item name field. Currently, the SNDMAIL options uses the commas to break down the item field into separates fields. Is there away I can...
Last updated: -
In LAN environment, is there any way to find out forgot password that I set for excel spreadsheet?
Last updated: -
How to get AS/400 macro to pull data from Excel
Hello I’m trying to create a macro on the AS/400 that will pull data from an Excel sheet and input data to the screen. I know how to create a macro to run the menu option by using the record macro button but not sure how to get it to access the excel file so it will run through the list.
Last updated: -
Excel Dashboard from AS/400 reports
A client has asked me to populate an Excel sheet with reports generated from an AS/400 system. Currently these reports are entered manually 1-2 times a day. What I want to do is pull the data directly from the AS/400 system rather than having it run the report, but I'm not sure where I would start...
Last updated: -
I have a case that the client work on an exists Excel file
I have a case that the client work on an exists excel file, she try to save the file on a different name, sines than the file was corrupted an could not be open at all. I try the auto save of Excel, but nothing there. I try several fix software but the most of them get me a blink results. Some of...
Last updated: -
Export data from Delphi to Microsoft Excel
I'm looking to export my data to Microsoft Excel from Delphi but I'm not sure about the process. I tried CSV but that didn't work. What's the best way to do it?
Last updated: -
How to lookup and match data in Excel
I need to look up data (number) from column B and match it to column R, and then display the corresponding cell from column S. so if B1= R3 then display S3. Help?
Last updated: -
How to automatically update Microsoft Excel charts
I have several charts in Excel that point to my data on the worksheet. The data is created from a VBA function. But when I tried to update it, my new data isn't being reflected in the charts. Did I do something wrong? What should I do?
Last updated: