Hey all, I just started seeing a new box of text in cell A1 when I show details /drill down into a cell of a pivot table, when it opens into a new sheet. It says " Details for blah blah (whatever the header of data I click)". The table that is generated now starts on row 3. Has anyone else seen this and know if there is a way to avoid this? Apparently this is a new update. Does anyone know of a way to disable this/revert back? It is going to cause a real headache for macros for me.
Can't visualise what you are describing, sorry.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Try it out and you should see, unless for some reason the update didn't roll out to you yet.Originally Posted by AliGW
As far as I know there is no way to turn it off (currently at least). I've seen a couple of complaints about it already, though I can see the logic behind the change.
Everyone who confuses correlation and causation ends up dead.
What is the logic behind it?
Having seen numerous workbooks at work that have various detail sheets in them with no indication of what dataset they were supposed to be, I think it makes perfect sense. It is typically MS to just do it without telling anyone or giving an option to switch it off though! You'll just have to program around it.
Last edited by romperstomper; 05-17-2024 at 03:41 AM.
crossposted: https://answers.microsoft.com/en-us/...4-08290576452e
Rule 7: Cross-posting Without Telling Us
Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.
Post a link to any other forums where you have asked the same question.
Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.
Read this to understand why we ask you to do this.
I have added the crosspost reference for you today. Please comply with this and all our rules in the future
However, if you continue to crosspost, you can expect to have your thread BLOCKED until you update it yourself.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
You guys watch other websites for people posting issues to get help on? How is that any of your business really? You are trying to moderate my life on the internet? FYI, I will post the solution I find on the other sites that I use, that way it reaches an even larger audience, not just one site.
Read this to understand. https://excelguru.ca/a-message-to-forum-cross-posters/
This is a common courtesy that almost all forum help sites ask that you adhere to.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks