User Profile
JKPieterse
Silver Contributor
Joined 9 years ago
User Widgets
Recent Discussions
References to old discussions lost
Is it correct that the entire discussion history of this community has been zapped with the start of the new interface? If the answer is no, how do I find old discussions? Home | Microsoft Community Hub For instance, where did this thread go: https://techcommunity.microsoft.com/t5/community-events-list/working-with-tables-in-microsoft-excel/m-p/103750858Views0likes3CommentsConditional formatting duplicates doesn't highlight them
I have the strangest thing. I have a workbook with three columns listing 4 rows of formulas preceded by an apostrophe, to convert them to text. Each row contains the same formula. I can prove it by doing a comparison =B2=A2, which yields TRUE. But if I try to highlight them using Conditional formatting, highlight duplicates, nothing gets highlighted! (see attached file and screen-shot below). What am I missing?1.1KViews0likes6CommentsGetting the sourceString of all pivot tables in a workbook
I'm trying to run through all pivottables in an Excel workbook and list their sources, but I'm not succeeding. I'm using code like this: async function SearchInPivots( context, wb: Excel.Workbook) { let foundPivots = new foundCollection(); let pts = wb.pivotTables.load("items"); let ptCt = pts.getCount(); await context.sync(); let ptColl = []; let pt:Excel.PivotTable = null; for (let i: number = 0; i < ptCt.value; i++) { pt = pts[i].load("getDataSourceString"); ptColl.push(pt); } await context.sync(); for (let i: number = 0; i < ptColl.length; i++) { console.log(ptColl[i].getDataSourceString()); } return foundPivots; } What am I missing? Cross-posted here:https://stackoverflow.com/questions/74178968/getting-the-sourcestring-of-all-pivot-tables-in-a-workbookSolved838Views0likes1CommentWrong place for a post
Hi, Can a moderator please move a post I put in the wrong section? It is about a translation issue of the Excel UI. Here is the post link: Wrong Dutch translation in Excel Options - Microsoft Tech Community I think it should go here: All Languages - Microsoft Tech Community1.1KViews1like5CommentsFeature request: remember filter state
I always filter for unanswered messages. But if I click a message and then hit the back button, this filter is discarded. This is something that annoys the heck out of me because I have to keep remembering to control-click messages so I do not lose that unanswered messages page.763Views0likes3CommentsDiscoverability of this forum area
Hi team, Wanted to report this, perhaps other users have the same issue. I had a hard time finding where to post comments on the forum itself the other day. It took me 20 minutes to find this area. Later, someone pointed me at the "Info center" menu item at the top. Perhaps this menu item needs relabelling or a tooltip?492Views0likes0CommentsForum reply window controls different
Hi Team, I wonder whether anyone can shed any light on the issue we've seen in this message thread: https://techcommunity.microsoft.com/t5/Excel/Create-a-pop-up-form-for-entering-current-block-of-cells/m-p/719622#M33460 where the OP has a different set of controls at the top of his reply window than I have. (screen-shots are in the thread)911Views0likes2Commentstechcommunity in other languages
On Answers, there were many different language sections, like this Dutch one on Excel: https://answers.microsoft.com/nl-nl/msoffice/forum?sort=LastReplyDate&dir=Desc&tab=All&status=all&mod=&modAge=&advFil=&postedAfter=&postedBefore=&threadType=All&isFilterExpanded=false&page=1 Where are these people supposed to go with their tech questions (on Excel)?730Views0likes0Comments