Forum

Hi Lucia, You can use formulas to add the missing details from category table (replace the placeholders with your real references). =INDEX(Categ...

As mentioned, aggregate user files into reports, you no longer refresh the original data, just the data split into user files. Not sure I underst...

Hi Reza, I suggest creating a new file for each user, with data organized in defined tables, then aggregate user files into reports. Typing data...

Hi Deval, We cannot recover formulas, there is no cell history to know what was there before.

Hi Nate, The behavior is similar to any pivot table: If you have Account Type as columns, for each account type all measures in the Values area will s...

Hi Robert, Will be better if you can provide the code, hard to say why from your description.

Hi Jack, Email items are just grouped into a conversation, but they are still individual items. If you want to keep some images and there is no...

Wonder why you cannot download the sample files, what happens? Anything can be done, you can overlap the 2 charts, they play with transparency of t...

Try to put these specific transformation steps in a function with table, column name as parameters of the function, then you can call this function as...

Hi Ted, I think you're looking for a sort of animation: See this topic for a similar solution:

There does not appear to be the 65,530 limit when you use hyperlink in a formula vs hard-coded hyperlinks. You still have to consider the impact ...

Here it is

Hi Karl, 32767 is the maximum value of a 16-bit signed integer. (2^15-1) However, there is no parameter in the code declared as Integer, OffsetRow is ...

Hi Steven, Some data types are no longer available: the service connecting Excel with Wolfram ended on June 11, 2023. Fundamental company data...

Hi Amien, Instead of a measure, have you tried adding a calculated column? Calculated column seems more appropriate to your scenario, as each result i...