1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Named Table and Named Range - more data than shown

I have a single workbook open. Previously, I added a table and named it tblLabInfo to use in a dropdown box I defined ddLabInfo. Everything works, but I remember adding the relevant information for a specific laboratory, yet it is not visible in tblLabInfo, but is available in ddLabInfo dropdown. Notice the underlined in "RED" laboratory names not in the tblLabInfo. I realize this makes no sense. What can be happening?

https://preview.redd.it/jzjy4lw0byyg1.png?width=2411&format=png&auto=webp&s=ffbc3501285456ef85bcccd8767fe4749e7d91a1

https://preview.redd.it/0lplukw0byyg1.png?width=866&format=png&auto=webp&s=784faaef958f48c8885f40bafa5693c520618c4d

https://preview.redd.it/6f3vgnw0byyg1.png?width=2030&format=png&auto=webp&s=add5b12197151aac1179cb8fbc5b974fdf3c1e46

https://preview.redd.it/ladxulw0byyg1.png?width=2385&format=png&auto=webp&s=a070233e403b9fb993be97900c02f1e569509985

submitted by /u/dcasciato
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#rows.com
#natural language processing for spreadsheets
#Excel compatibility
#Excel alternatives
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Named Table
#Named Range
#tblLabInfo
#ddLabInfo
#dropdown box