2013

I have a file that has been sent to me by a third party that was created in Excel 2013. I have 2007 as our standard issue at work. The file has been sent to me in both xlsx and xlsm form. In both cases, the file opens fine in 2007 but in the case of 3 tabs only, just the act of selecting any...

Good afternoon all, I'm using Excel 2013. When I add in blank rows to a pivot table ('insert blank line after each item' in pivot table design options) and then try to format them in Pivot Table styling ('Blank Row' in the styling options), the formatting only applies to the first blank row in...

Hi, I have a value for a volume eg. 24 L and I want to split this so I just have the volume unit (in this case L). The values are delimited so I can't use string functions. 24 L is in the cell R2. There can also be values such as 16000 KG. There is always a space between the value and the...

I've been programming for Excel since about 2002, and have never run into problems quite like these. Some users in our office are moving over to 2013, and from minute one, problems are starting to show. The core of the WB is that it's an ODBC connection to a database (Query Table), and then...

hello again, I have below questions with which I need help/suggestions please. 1. A userform created in excel 2007 which has calendar control option in additional controls - will this work as it is if system having 2013 on it? 2. How do I get Calendar control in 2013? If not, the code? 3. I...

I know how to do a typical transpose of numbers, but this is trickier. I'd like to transpose the curricular name and date completed to go across the spreadsheet until a student name changes, and then start the transpose again. Here is a sample of the data I'm working with. I need it to...

hello. im new to excel and im working on a project dashboard using excel 2013. is there a way to create a textbox in a chart when i click a userform button? one textbox per click. and im unable to use activeXcontrols in my excels. it says " cannot insert object" please help :confused:

Just as the title says - the radio buttons cannot be selected, and the user also can't right click on them. I struggled to find someone else who had the same problem, but we followed the steps in these two posts and it did not fix it: unable to click ActiveX control and form control Excel 2010...

I have some VBA code to run through my excel files in a specific folder that pulls information to a master sheet. The issue I'm having is that some of my file names, which is the companies name and I can't change them due to other macros that use these same files, have an "&" in their name like...

Program Version: Microsoft Excel Professional Plus 2013 (15.0.4737.1000) (all updates) OS: Windows 7 Home Premium 32-bit I recently started using Excel 2013 and I am having trouble with comment boxes. When I resize the box to make it larger, it is easy to do because I can see the frame...

Hello, I recently upgraded from Excel 2010 to 2013 and am having an issue with pasting. Basically, I have spreadsheet with multiple cascading (+) line items (see link below). the additional cascading line items breakdown data by date: Image 1: Imgur With 2010, I was able to select the rows I...

Hi, I'm having an issue with Excel 2013 disabling Macros without notification when opening a workbook using VBA in another workbook. I've tried all of the obvious security setting combinations but I can't even get a notification to ask if I want to disable macros, they are just automatically...

I want to move the first row of excel Table to the end of Table and another VBA to move the last row of Table to the top of Table.

Hello there, now I got this very annoying situation with my Excel 2013. Ever since some updates were installed, I can't enable macros in Excel. Even after changing to "Enable all macros" in macro settings I receive an Compile error. After switching back to "disable all Macro with notification"...

This has got to be easy, but I've looked through hundreds of posts and can't find just what I need. Using Excel 2013, I have created a userform with a combobox. The combobox values (a list of names) are built dynamically from selected rows in a column on the spreadsheet using .additem. When a...

Hello, I have a file with multiple tables in powerpivot and I've set up a system with macros that send automatically PDFs to email recipients. What I've not been able to do at the moment are two important steps that could help me save more time. 1. I've created a task which opens the file in...

I am copying from one workbook to another. This code works fine in Excel 2007. However, it freezes each time in 2013 on the .Close portion. Any idea as to why this would happen? There is no issue with the path, and this code has been run hundreds of times in the previous version of Excel so it...

We have an application that works fine up to MS Excel 2010. M$ changed from an multiple-document interface to a single-document interface in 2013. Now the behavior of my application has changed. Each workbook now opens a completely separate instance of Excel (SDI). That's fine and all works...

Hello, I have a macro that searches a folder on my desktop for a particular image and then inserts it into a designated column. Sku's listed are in column D. Respective images get inserted into column C. Sub ProcessFiles() Dim sPath As String, s As String, r As Range Dim shp As ShapeRange Dim...

So I have recently updated from office 2010 to office 2013. I previously had a macro which send out personalised emails to a list of recipients and attached a series of files. This worked perfectly in 2010 but is throwing up an error in 2013, looking for some advice with this. Sub EmailMacro()...