Forum

Yeah, I agree it's not ideal. Hope you find a workaround.

No file attached. Be sure to click the 'start upload' button after selecting your file. I can imagine there's a setting for preventing hyperlinks f...

Hi Katherine, No, it's not designed to work that way. If you want to circumvent the process you'd have to write some VBA code that unlocks the work...

Hi Alexandra, The hyperlink will always highlight the range you're linking to. I'm not sure why it's not working for a single cell. It shouldn't ma...

Hi Damian, You have filtered the column in the TIPT query for rows that 'equal' TIPT. Power Query is only finding exact matches, not any instance o...

Hi Andrew, Please share the file again that illustrates the error. Mynda

Hi, Please see the attached file which contains INDEX & MATCH formulas that lookup the various criteria individually and then find the maximum ...

Not sure what you mean by 'should the date be placed in another column'. Do you mean in the lookup array or the lookup value?

Hi Alexandra, Welcome to our forum! I wasn't able to recreate the problem using a dashboard embedded in a SharePoint Page and creating a hyperl...

Hi Dave, There is a setting in the Conditional Formatting rule dialog box that allows you to apply the rule to 'all cells showing...' based on the P...

Hi Katherine, The cells you want users to paste into would need to be unprotected before pasting. They can't paste into a range of cells that conta...

Hi Andrew, There's no setting as such that you can turn on that converts your formulas to values. The only way to do it is to copy and paste them a...

Hi Andrew, VLOOKUP is looking up column A of the fact_player_technical sheet for the date in column K and value in column L of the Dashboard_team_P...

Hi Damian, The file didn't get uploaded. Please try again and be sure to click the 'start upload' button after selecting your file and wait for th...

Hi Martha, Welcome to our forum! How did you add the monthly data to the source data? How was the source data generated? If it is a query, then ...