I'm using SSMS 2014 and I'm able to link an Excel file as a linked server. But here's my question: Now I want to link multiple Excel files. Can I link all of the files on a linked server or do I have to do them separately? Meaning one linked server for one Excel file.

I have Office 365 on my desktop. I just received an email in Outlook from a co-worker with an Excel file attached. But I can't preview the file at all. Here's the message I'm getting: This file cannot be previewed because there is no previewer installed for it. I tried just to open it with no luck....

This is probably an easy question to answer but here I go. I'm a teacher and my students enter data into an Excel spreadsheet. But every single time, the value they put in changes. For example: 2.14 changes to 2 How can I format it in a way that it keeps the numbers behind the decimal point?

So I'm trying to work on an Excel spreadsheet and I've run into an odd issue. These so called Excel 'tooltips' are popping up all across my screen. And popping up over each other. Is there anyway to stop this? I can't get any work done at all.

How do you group a list of companies/account numbers that are duplicated on several rows (separate purchases) to identify companies that purchased specific products within 2 code ranges (c50-c509, c18-c20.) and include ALL of the that companies purchase rows regardless of the product code in that...

Okay, so I have an interesting question. I was sent a Microsoft Excel spreadsheet and I need to delete parts of different cells. Meaning everything after this symbol '*' needs to be deleted (including the symbol). For example: JohnSmith*22101 This is how it should look after: JohnSmith It's too...

I have roughly 20 or so batch files that I need to transfer to Microsoft Excel. Meaning - I want to transfer all of the contents of the files into Excel (which would make a list). What's the best way to do that? Thank you!

Whenever I open up Excel for Mac, I keep getting this message: Excel saved changes to the file before the application quit unexpectedly. And it forces me to go to the last saved version (even though my last session ended fine without any problems). So I've come to the conclusion that Excel thinks...

A few hours ago, I saved a XLSM file (Microsoft Excel). When I just tried to open it, it's not working. I sent it to my co-worker and he was able to open it just fine. He sent it back to me and it's still crashing. We're still on Windows 7. Any reason why this would happen?

I have assigned a command button that would assign a specific width to each column in a Microsoft Excel spreadsheet. But I sent it to a friend and when we tried to use the command button, the widths were all different. It's the same characters fonts too. What's wrong here?

Hi, Does anyone if it's possible to add / insert a bullet point list in Microsoft Excel? I know how to add a line break inside a cell but I think a list would look much better for my presentation. Thank you.

So in Microsoft Word, I'm easily able to count the words in a document. How can I count words in a Microsoft Excel file? I don't see it anywhere. Is there an easy solution for this? Thanks for the help.

Hopefully I can explain my issue clearly. I'm using Excel 2016 for Mac and I found out that it doesn't support user forms. Here's what I need to do: Add new rows to my table using an input field so I can only add new entries through that field and can't modify the rest of the sheet. Is this...

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy