I notice that a large worksheet creates Excel resource errors at about 100 columns. Memory is not the culprit but rather Microsoft's sizing of stacks or heaps where pointers keep track of things is. I don't understand why Microsoft imposed this limit while expanding the spreadsheet rows and...
Is there a way to highlight that a response to a post has an additional question as part of a response? For example, a recommended solution works but the overall effect creates another problem. If the respondent could tag or trigger a flag that shows all members that another question exists, it...
Hi all, I am trying to figure out how a chart can display a text color based on the data value. for instance, on a bar graph, I want the positive values to show black text and the negative values to display red text.
I can make the text color match the value (conditional formatting) but the...
Hello, first time poster to the forum. We want to display the filename/tab of the linked spreadsheet that provides the data in an adjacent cell. We can do it by linking to a cell with file name / tab, but we would like to do it by looking at the linked formula and pulling the filename / tab from...