Issues with programming Slicers - Excel 2010
not a good idea, ThisWorkbook has special meaning in Excel, ActiveWorkbook is probably safer. I wouldn't get too fancy with this stuff, just get it to work. Why? slicers are brand new in 2010 and the …
Importing *.DBF files into Excel 2007 - social.technet.microsoft.com
Try Excel DbfMate Add-In. It allows importing data from DBF files directly to worksheet, and exporting data from worksheets to DBF files using both GUI and VBA.
Excel Data Labels - Value from Cells - social.technet.microsoft.com
When I reopen the workbook and add x and y value and a new label (where I left empty cells to do so) that data point 'icon' comes on to the graph, but the datalabeldoesn't automatically populate. When I …
User can't save excel file to sharepoint
We utilize an excel spreadsheet saved to SharePoint online co-author between users. One user has now found that she can't save the file - it just hangs and shows it is processing. She can press …
Unable to save and update excel files directly to SharePoint
Can you add yourself to the list permissions directly to ensure you have access and that inherited permissions aren't broken to that list and test the excel saving?
Embed Excel worksheet - allow view without sign-in
Are you display the Excel worksheet in an Excel Web Access Web Part? From your description, when you embed a Excel worksheet in your page, it required users to sign-in to display the contents. You …
Excel links resize themselves in word - social.technet.microsoft.com
Aug 28, 2013 · Lately some of my users have been having an issue when they copy data from excel 2010 and then using paste special>paste Microsoft Excel Worksheet Object into Word 2010 with the …
Where to save Query Editor Steps (Excel 2016)
According to this article, Power Query (Get & Transform) keeps track of everything you do with the data. The Query Editor records and labels each transformation, or step, you apply to the data. Whether the …
Why can't I enable Macros in Excel 2010? - social.technet.microsoft.com
Jul 30, 2013 · When I open an Excel 2010 spreadsheet, there is a message "Macros must be enabled in order to use this workbook."
excel 2007 file open in read-only (compatibilty mode)
We have a 2007 excel spread sheet that was saved to 2003. When it is opened via the web with excel 2007. it opens in read-only (compatibilty mode). We saved the file in 2003 format because many of …