4,380 questions
Hi Lucy, could you find any solution for this? I have the same issue
How to Display Full Data Results Instead of Preview in Excel Copilot's Advanced Analysis?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 71%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELG%3C/text%3E%3C/svg%3E)
Lucy Gardner
45
Reputation points
I am using advanced analysis in copilot through excel in order to use python to create a model that analyses my data. When I get my results printed in a new sheet, it only shows a preview, is there any way to avoid the results being shown in a preview format? Ideally I want to see all rows of my data. I have tried changing the python script in order to save the results in a new sheet within the excel or save it to a new file completely, neither worked.
Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
3,920 questions
Microsoft Copilot | Other
959 questions
1 answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 83%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yildirim K 5 Reputation points2025-03-12T15:07:38.9033333+00:00 -
Lucy Gardner 45 Reputation points
2025-03-12T15:15:34.4266667+00:00 Hi, the best I could do was copy the Python code created by Copilot into a python cell then turn that into an excel object and it would display the full results - not sure if thats the best way but thats the only way I could find
Sign in to comment -