issues

We recently upgraded to excel 2016 and when I try to open my workbooks with macros they try to open then close. If I open another workbook or blank workbook then open the workbook with the macro, I do not have any issues. If I did try to open the workbook with the macro first, then opened a...

I am trying to get a spreadsheet working for a game I play which is useful information. The spreadsheet is hosted here and I saved a copy to my own Google Sheets. I wanted to make some changes and add some things but I'm running into issues. There appears to be differences with Google Sheets and...

I have an Excel workbook with two sheets, basically a one-to-many setup between the two sheets. The first sheet lists projects and the second sheet lists the issues for each project. The second sheet has filters on each column What I am attempting to do is have a user click the issues cell on...

I have a workbook with a rather complex set of vba UDFs used to perform thermodynamic flash calculations. Multiple vba routines are called for each udf call. There may be +100 individual UDF calls within a work book across multiple sheets. Many of these will be interlinked with functional...

Hi everyone. I am almost done with my project, but I need help with something. Can someone help with getting the following to work? SELECT ID as Eval, "Preparation and Punctuality" AS Criteria, I_Q1 AS Grade, =IF([I_Q1]=1,"F","ERROR") AS LETTER_GRADE FROM issues UNION SELECT ID, "Subject...

Hi One time someone told me there are so issues with structural tables (Insert-->Table) when it come to ??? (I do not recall, when it come to sorting, or searching, or filtering). I do not recall. I tried google "issues with structural table but could not find clear answer". Would appreciate if...

I currently am able to use vba to comment a picture I have rooted in a specific cell, but am having trouble sizing it properly. My current code is below: Sub Comment() Set rng = ActiveSheet.Cells(9, 1) rng.AddComment rng.Comment.Text Text:="" rng.Comment.Shape.Fill.UserPicture...

Hi, good afternoon, just wondering, I have the code below which at the moment copies all data from one sheet to another, but is there any way to collate data which shows a specific word in rows H? for example the word Issues'? so if issues show in row H can it copy all the data in that range and...

I am having to refresh a pivot table and whenever I do that the month disappears. Please help! I’m working off a pivot someone else made and am having issues figuring out what’s connected to what.

Excel crashed and when it started back up again the ribbon had changed to the new version. The icons have less color and depth, and the tabs are no longer differently colored when selected. I have some visual issues, and this makes it harder for me to find things. I saw an article that said...

Hi gurus, I am looking for a VBA solution to check a cell which contains several updates and only keep the latest update, each update has its updated date and time. See the example below: <tbody> M 2 2018-05-18 01:02:09 - K (Work notes) As per suggestion, implemented the fix. No...

Has anyone else noticed that offi efor excel is vastly slower and more unstable than 2013/2010. I have multiple users that are experiencing lock ups, hanging and even white screens after moving from 2013 to 365. Some of these issues have been resolved in build 1807 compared to the dreadful state...

Good Morning, I am attempting to update my excel code as originally split he code per quarter. I have fixed most issues to make the code generic, what I am having issues on is a formula to do a vlookup. any suggestions to complete the fix. ActiveCell.FormulaR1C1 = _...

Hello, I am using the indirect formula to link information from another spread sheet. Whilst the formula does work there are 2 issues with using this: 1, The file is very slow and takes minutes to update as opposed to seconds 2, Unless the linked files are all open the formula result shows...

I am trying to use the USA example file for this. I can't get the program to recognise the file for the charting package even though I am following the instructions. I get this warning: The selected file type does not support workbooks that contain multiple sheets. I can't even see the mutiple...

I fetch a report in the below format. I want date value to be copied in column C. For an example : First group of data is related to 6/8/2018 in which I need date to be copied in corresponding cell to "Group Value" till last ID given in that group or before the next date comes in and so on. Data...

I am running into some issues between Excel 2010 and Excel 2013; if I have on Excel 2013 and open and run it in Excel 2010 worksheet.protect Password:="pw", UserInterfaceOnly:=True I run into no issues but if I have worksheet.protect Password:="pw", UserInterfaceOnly:=True...

Morning, Afternoon or Evening All, Now i am not sure if this is in the right area but it is based around excel. I currently have a excel file which is designed to work on a touch screen where a user scans in a serial number then touches different pictures to highlight issues with a product...

Hello! I would first like to apologize if this question has already been posted and answered numerous times but I was unable to find the right wording for my question to find a thread that matched. In short, I have a sumproduct formula with multiple criteria that helps identify the number of...

Hi guys, Just need someone to error check my code, it works for half of the syntax but leaving the first statement out? Code: "=AND(OR(D2<>$I$4,D2<>$I$5),ABS($E2)>0.01)" So the code runs for the ABS(E2) portion, but seems to not care about the first D2 part. I have two cells with values...