workaround

Hi, I am having 3 workbooks, called A, B and Master. Basically, A and B workbooks have the same format table with some data based on different stores. Every week new columns will be created with a new date in workbooks A and B. I want to again look for and extract data based on the...

I got a code that works well in vb, but the code uses listbox hwnd. this property do not exist in vba, is there a workaround for this?

Hi, I just got caught out on something I haven't encountered before and I'd like to know if there is a proper solution or just the workaround I can think of. FYI I am joyously working on Excel 2010. I have a pivot with 3 series of values. However when I double click on any one of the totals it...

Hello, I noticed that when I'm using "Freeze Pane", my Draw tool becomes greyed out. Is there a workaround? Thanks! Anita

When using a userform and you have to select a different workbook to enter data and then go back to the userform it causes errors when clicking any buttons or enter text. Only workaround I found us activate this workbook for every button on the userform. Is there an easier way to do this.

Hey all, Right now I'm working on having a statistical Excel file on my company's SharePoint server. Right now that is working fine as a test with only me using the file. When it goes live the obvious bottleneck is that we have perhaps 20-25 people using the file as various points of the day...

Is it possible to not allow a specific user to view specific tabs and only see others w/o actually hiding the tabs and creating a password? Any workaround for this? I'm trying to save myself the time of hiding and unhiding tabs so frequently.

Morning all, I only just discovered my favorite Excel forum has a Power BI section : ) I am searching for a workaround to bypass my Circular Dependency issue. I have searched for answers on this but because I am new to Power BI I am unable to solve my issue with the explanations I've seen...

Hi Is there a limitation on the number of cells you can import? I have a file with 209 columns and 500 rows but PowerQuery is only bringing in the first 128 rows - is there a workaround to this? Many thanks

When I do VLOOKUP from another sheet, the resulting data is not searchable to the current sheet where I have the VLOOKUP formula. Why is this and what's the workaround? Please help.

Hi, I need to have cell “A1” in my current worksheet linking to a particular cell in an external workbook, called for example Sample_workbook1.xlsx. Cell “B1” contains the location of this cell in string format. Eg...

After scouring forums, I have yet to find a solution to sharing an excel workbook without losing several features (Eg: macros, tables etc). I have built a Customer Relationship Management (CRM) system within excel and have a need to share it with three other users. Unfortunately, many of the...

Hello everyone, this is my first post here. I am using Excel 2013 on Windows 8.1. I have posted my issues on Reddit before, without results unfortunately. I am currently manipulating a very large dataset (500k rows approximatly) that I need to reorder before analyzing the data. This picture...

Hi Brilliant People, I know there have been posts for workarounds, but I can't figure out how to apply to my code, because I am a complete novice when it comes to vb. Years ago, I created this code to 'mine' a bunch of excel files in a directory and extract a data table I'd hide in the...

Hello! Running into an issue when trying to create a 3D Sumproduct formula, which I have come to find out is not possible in MS Excel 2010 since the Morefunc add-in is not compatible, to use THREED function. Trying to figure out the work around using a "SUMPRODUCT(N(INDIRECT" function, but...