NEW Python in Excel - PYTHON + EXCEL + ChatGPT = Easy!

Рет қаралды 209,574

Күн бұрын

How to use Python in Excel natively using libraries like Pandas, NumPy, Matplotlib, Seaborn and more. In this video I'll show you how to use Python in Excel to do data analysis and create amazing Python charts, aka Python plots.
Don't know Python, don't worry, I'll show you how to use ChatGPT to write the Python code for you and cover the error messages you might experience.
⬇️DOWNLOAD the example file here: www.myonlinetraininghub.com/p...
📝 Note: At the time of recording Python in Excel is currently available to Microsoft 365 Office Insider users on the Beta Channel: insider.microsoft365.com/join
❓ Are you excited about Python in Excel? Please let me know in the COMMENTS.
🎓 LEARN MORE in my Excel courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
0:00 Python in Excel
0:57 Import Python Libraries in Excel
1:57 Defining Dataframes from Excel Data
3:16 Descriptive Statistics in Python
4:05 How to Use ChatGPT to Write Python
6:27 How to Create Python Charts in Excel
9:11 Python Errors in Excel

Пікірлер: 497

@MegaTrickykid 11 ай бұрын

Absolutely amazing, Mynda. You have already pushed open another door! What you have demonstrated here is absolutely fantastic. Many thanks also for the working material, which I immediately downloaded from your website. warm greetings from Berlin!

@MyOnlineTrainingHub 11 ай бұрын

Awesome to hear 🙏 have fun with it.

@davidbristoll195 11 ай бұрын

This is a game changer. When I considered the possibility of using Python in Excel, I was thinking it might be in place of Visual Basic and hadn't considered the possibilities of using libraries as you've demonstrated. I'm still interested in the possibilities of using for loops to iterate through lines for some unusual requirements I might have, so I'll explore more. Thanks for sharing this info in such an easy to understand and follow way 👍🏻

@MyOnlineTrainingHub 11 ай бұрын

Cheers, David! Sounds like you have some ideas ready to go. Have fun with it 😊

@garydunken7934 11 ай бұрын

I love Excel AND Python, and been working with them for years. This is very exciting indeed! Thanks for the news.

@MyOnlineTrainingHub 11 ай бұрын

Great to hear!

@benjaminnzioki8815 11 ай бұрын

This is awesome! I must admit I am struggling to catch up with new Microsoft Apps and features. Thanks, Treacy for always providing relevant use case descriptions.

@MyOnlineTrainingHub 11 ай бұрын

My pleasure! I know, it's a lot even for me, and I write about it for a living 😁

@ziggle314 11 ай бұрын

Game changer. Can't wait for it to move beyond beta. Thanks for the briefing.

@MyOnlineTrainingHub 11 ай бұрын

Glad you're excited about it!

@TopBam 11 ай бұрын

Always wanted to learn Python, now I have a reason! Thank you, Ma'am!

@MyOnlineTrainingHub 11 ай бұрын

Go for it!

@AlvinRyellPrada 11 ай бұрын

Wow this is really awesome! Looking forward for full deployment of Python in excel for data science! excel never ceases to amaze me in making itself relevant! thank you for sharing this, Mynda!

@MyOnlineTrainingHub 11 ай бұрын

🙏Great to hear you're excited about Python in Excel!

@Flylikea 11 ай бұрын

Same, Python is very user-friendly (especially with all the sources available and chatgpt)

@snipelite94 11 ай бұрын

The power of python is that it has no limitations on the number of records in BIG BIG DATA!! 😁 I'm waiting to see if being tied to an excel spreadsheet will install a ceiling on data size 😣 Also, can we pip install any of the python libraries and then import them for use in excel ? Excel already does dataframes/tables and charts, but, traditionally, we've have to skedaddle to VBA to process text mining stuff. However, I'm looking forward to the general release to take it for a test drive. Thanks for the intro, Mynda 👍

@lawrencedoliveiro9104 11 ай бұрын

This will be a great way of squeezing some more revenue out of Excel jocks too dumb to realize that you can completely bypass the whole Microsoft bit and make direct use of Python and NumPy and Jupyter and Pandas and Matplotlib and all the rest of it ... for free.

@ExcelCampus 11 ай бұрын

Great video Mynda! So many new things to learn and explore in Excel.

@MyOnlineTrainingHub 11 ай бұрын

Thanks, Jon! It's exciting times!

@Cytotube2 11 ай бұрын

Mynda, thank you so so much!! News and insightful tutorials like this keep me excited for your new videos. Python is Excel is so exciting!!

@MyOnlineTrainingHub 11 ай бұрын

My pleasure! Have fun with Python in Excel 😊

@alangrinsteinner4033 11 ай бұрын

This was amazing. I look forward to each Excel Newsletter but this installment was Epic. Thank you Mynda...you continue to deliver value with each newsletter.

@MyOnlineTrainingHub 11 ай бұрын

So thankful you like them 🙏😊

@richarddunks7703 11 ай бұрын

This is great! Thanks for the comprehensive overview. I'm looking forward to playing with this.

@MyOnlineTrainingHub 11 ай бұрын

Great to hear!

@leeotzu 11 ай бұрын

Wow, this is a game-changer. I can't wait to get it through the Office 365 beta channel. Thank you

@MyOnlineTrainingHub 11 ай бұрын

Great to hear!

@afhlmd 11 ай бұрын

wow, wow, wow. That's what i have to say about it. Thank you so much for bringing this to us Mynda. You're the best

@MyOnlineTrainingHub 11 ай бұрын

So glad you like it 🙏😊

@sc100200090 11 ай бұрын

Excellent!!! Python + Excel + ChatGPT is a Chat worth while!!!! Well going amazing enough Mynda!!!

@MyOnlineTrainingHub 11 ай бұрын

😁 sure is! Glad you liked it 🙏

@kevinmcfarlane2752 11 ай бұрын

Be aware that besides ChatGPT and Bing, there are other Chat AIs out there as well. From my experiments with code (and in general) no one AI gives the best answer for every prompt. So it’s often worth comparing at least a couple at a time.

@yassirkhalid5376 11 ай бұрын

The Microsoft Teams working on Excel are brilliants! You can't sleep these days with these fast moves...

@MyOnlineTrainingHub 11 ай бұрын

😁it's a moving target of learning!

@SplitSniper7 11 ай бұрын

This is awesome! Thank you for sharing, cant wait for this to come to the regular user

@MyOnlineTrainingHub 11 ай бұрын

Hope you enjoy it!

@malcolmvaneyck1968 11 ай бұрын

This is just awesome and it will tremendously change certain things in my line of work. Thank you Mynda!

@MyOnlineTrainingHub 11 ай бұрын

Wonderful!

@WorkoutLoverOfficial 11 ай бұрын

Your Brilliance I can't wait to use python in Excel. it is incredible. Thank you!

@MyOnlineTrainingHub 11 ай бұрын

So pleased you're looking forward to it!

@miguelangelponce8553 11 ай бұрын

Thank you Mynda ,A'm amazed the way this goes beyond and out of limits

@MyOnlineTrainingHub 11 ай бұрын

Always something new to learn with Excel 😊

@Vikram_8621 10 ай бұрын

This is so valuable! thank you so much! 🙏

@Acrnl 11 ай бұрын

This is great great. Looking forward to see more insights into Py usage. Well done

@MyOnlineTrainingHub 11 ай бұрын

Thank you 😊

@Seftehandle 11 ай бұрын

This is phenomenal work! Thanks Mynda!

@MyOnlineTrainingHub 11 ай бұрын

Sure is! Have fun with it.

@Mandelbrot567 11 ай бұрын

This is fantastic news. I stopped learning VBA a while back and switched to Python. I have seen in some job postings some companies are looking to update legacy Excel and this may be an option in the future.

@MyOnlineTrainingHub 11 ай бұрын

The options seem almost endless now 😊

@QuantumIdeas 11 ай бұрын

Wow, it only took me 1 min to watch the video to press subscribe and click the like. That's how awesome this video is.... Cheers!

@MyOnlineTrainingHub 11 ай бұрын

Awesome! Thanks so much 😊

@Khan-mc3gi 11 ай бұрын

wow it will be game changer for data analytics u made great video thanks alot

@MyOnlineTrainingHub 11 ай бұрын

Glad you think so! 🙏😊

@mogarrett3045 11 ай бұрын

now this is really a game changer....thank you so much

@MyOnlineTrainingHub 11 ай бұрын

Sure is!

@jenbac.s1858 11 ай бұрын

Wow! Amazing! Now i have more drive to learn Python! Guess what! In Excel ! Thank you, Mynda🎉❤

@MyOnlineTrainingHub 11 ай бұрын

Wonderful!

@IgnitedVisions 11 ай бұрын

This is an awesome tutorial. Thank you for sharing it!!

@MyOnlineTrainingHub 11 ай бұрын

Glad you like it!

@gesalerico 11 ай бұрын

Mynda, thank you again, my best excel teacher!

@MyOnlineTrainingHub 11 ай бұрын

Glad you like it! 🙏😊

@rachelle5432 11 ай бұрын

SO EXCITED!!!

@MyOnlineTrainingHub 11 ай бұрын

Great to hear!

@joaocustodio2094 11 ай бұрын

Mynda, thank you very much for this great news, which will open up lots of possibilities in Excel.

@MyOnlineTrainingHub 11 ай бұрын

Glad you're excited to use it!

@Terracotta-warriors_Sea 11 ай бұрын

Thank you for this wonderful feature!

@MyOnlineTrainingHub 11 ай бұрын

The Excel team did an amazing job!

@cato451 11 ай бұрын

Amazing add to make excel even better. Thank you!!

@MyOnlineTrainingHub 11 ай бұрын

Glad you like it!

@yashison 11 ай бұрын

Amazing, thanks for the quick reference.

@MyOnlineTrainingHub 11 ай бұрын

You bet!

@KlinAprimora 11 ай бұрын

Mynda, what an incredible thing to see! Even not knowing a thing in Python, of course it is widely known that it is amazing and will bring new endless possibilities to Excel!

@MyOnlineTrainingHub 11 ай бұрын

Exciting times 😊

@tobateksingh4933 11 ай бұрын

Continue it. Thanks

@kumarsb 11 ай бұрын

Thank you for a great intro to Python in Excel

@MyOnlineTrainingHub 11 ай бұрын

Glad you liked it!

@sandravukovic2901 11 ай бұрын

Great tutorial, thank you so much!! ❤

@MyOnlineTrainingHub 11 ай бұрын

Glad you liked it 🙏😊

@manikandankbis7977 11 ай бұрын

Excellent videos.. i always loved to listen to your classes..

@MyOnlineTrainingHub 11 ай бұрын

Thank you! 😃

@stephenkaltenhauser2671 11 ай бұрын

Thank you Mynda! Fantastic!😊

@MyOnlineTrainingHub 11 ай бұрын

Glad you liked it!!

@user-cg9ns8id3x 11 ай бұрын

All I can say is, 'endless possibilities.' I cannot even begin to imagine the extent of Excel + Python. I will certainly come back to this post.

@MyOnlineTrainingHub 11 ай бұрын

Exciting times 😁

@davicapatonascimento8543 11 ай бұрын

Hi, excellent news I am making a course of Python and this news went the but amazing in this moment. I wiil go many jobs with python and excel. Thanks

@MyOnlineTrainingHub 11 ай бұрын

Best of luck!

@ricardomantovaniassis 10 ай бұрын

Thanks Mynda. You rocks 🙏🙏🙏🙏

@MyOnlineTrainingHub 10 ай бұрын

You are so welcome 🙏 😊

@stopthink9000 11 ай бұрын

Very cool!! Two of my favorite things together like pizza and beer! Cant wait until its in wide release.

@MyOnlineTrainingHub 11 ай бұрын

😁enjoy!

@Abu.Al_Mortaja 10 ай бұрын

Thank you Mynda🌹

@MyOnlineTrainingHub 10 ай бұрын

My pleasure 😊

@yannkitson116 11 ай бұрын

I know Python so this is great, thanks for sharing.

@MyOnlineTrainingHub 11 ай бұрын

Glad you liked it!

@stephencooper3583 11 ай бұрын

Exciting!

@MyOnlineTrainingHub 11 ай бұрын

Indeed 😁

@shrikantbadge3978 11 ай бұрын

Thank you so much. Every video is valuable.

@MyOnlineTrainingHub 11 ай бұрын

Glad you like them!

@marcelo_urban 11 ай бұрын

Belíssima explicação! E que simpatia!!!

@MyOnlineTrainingHub 11 ай бұрын

Obrigado!

@Thembatimba 11 ай бұрын

This is a definite game changer 🙌👏🙏👌

@MyOnlineTrainingHub 11 ай бұрын

Sure is 😊

@TheCraigie007 11 ай бұрын

Simply Loving it. Excelthonic!

@MyOnlineTrainingHub 11 ай бұрын

😁

@MarekBernolak 11 ай бұрын

Great material. 🚀🚀

@MyOnlineTrainingHub 11 ай бұрын

Glad you think so!

@flexyourdata 11 ай бұрын

Great explanation, thanks!

@MyOnlineTrainingHub 11 ай бұрын

Glad you enjoyed it!

@titusmusau2091 11 ай бұрын

Really excited to learn python and use it in my data analytics. I'm currently training at ALX Africa in partnership with Explore Academy.

@MyOnlineTrainingHub 10 ай бұрын

Awesome to hear!

@riverbluesky 11 ай бұрын

Thank you for a great explanation

@MyOnlineTrainingHub 11 ай бұрын

Glad you liked it 😊

@GuyOrlov 11 ай бұрын

wowser it will change data world thanks!

@MyOnlineTrainingHub 11 ай бұрын

Indeed!

@pablobonilla9498 11 ай бұрын

Great info !!!

@MyOnlineTrainingHub 11 ай бұрын

Glad it was helpful!

@JimFikes 11 ай бұрын

I am so glad that we finally have Python in Excel.

@MyOnlineTrainingHub 11 ай бұрын

Great to hear, Jim! Have fun with it.

@mykola_kanyuk 11 ай бұрын

very very excited

@MyOnlineTrainingHub 11 ай бұрын

Great to hear!

@muntazirabidi 11 ай бұрын

Wonderful. Thanks for the video.

@MyOnlineTrainingHub 11 ай бұрын

Glad you enjoyed it!

@rachaelhanna8523 11 ай бұрын

This is fantasic - My job will never be the same!

@MyOnlineTrainingHub 11 ай бұрын

Great to hear you’ll be making use of Python in Excel 😊

@elijahajayi987 11 ай бұрын

Incredible👏

@MyOnlineTrainingHub 11 ай бұрын

Glad you're excited about Python in Excel 😊 Have fun with it!

@LuisCarlosChavez717 11 ай бұрын

Super Awesome!

@MyOnlineTrainingHub 11 ай бұрын

Great to hear you're excited about Python in Excel 😊

@paulmartineau3850 11 ай бұрын

Thanks for this video Mynda. This is powerful stuff. I already use python and being able to use the python libraries with Excel is exciting. I wonder if you will be doing courses with Excel and Python Libraries in the future. If you do, let me know.

@MyOnlineTrainingHub 11 ай бұрын

Great to hear you're looking forward to using Python in Excel, Paul! I'll keep you posted regarding any new Python courses 😊

@fluffyhoneytina 11 ай бұрын

how exciting, something new

@MyOnlineTrainingHub 11 ай бұрын

Have fun with it 😊

@h2nrlc 11 ай бұрын

Thanks for share, very useful 🙂

@MyOnlineTrainingHub 11 ай бұрын

My pleasure 😊

@andrewcharlesmoss 11 ай бұрын

Python integration opens up a whole new world of possibilities! One grumble I have, though, is I can’t help but think we need the Advanced Formula Environment to replace the formula bar we’re so used to. It doesn’t seem right typing Python code in the current one!

@MyOnlineTrainingHub 11 ай бұрын

I agree, the AFE would be ideal for Python. It may well work. I haven’t tried it yet.

@lukev730 11 ай бұрын

Awesome Teaching…

@MyOnlineTrainingHub 11 ай бұрын

Thank you! 🙂

@ricardostorck 11 ай бұрын

Amazing!!!

@MyOnlineTrainingHub 11 ай бұрын

Glad you think so!

@consultcorpgroup1231 11 ай бұрын

Magnificent 👍

@MyOnlineTrainingHub 11 ай бұрын

It's super exciting!

@moaiedbetamour6078 10 ай бұрын

I love your videos

@MyOnlineTrainingHub 10 ай бұрын

Thank you so much!

@TaxMentors 11 ай бұрын

Awesome video

@MyOnlineTrainingHub 11 ай бұрын

Glad you enjoyed it 🙏

@MrJarod2003 11 ай бұрын

good video ! yes again

@MyOnlineTrainingHub 11 ай бұрын

Glad you liked it!

@edwardeggleston3612 11 ай бұрын

Thank you Mynda. yet another feature to help confuse us oldies. Just kidding, we will get our minds around it eventually I guess.

@MyOnlineTrainingHub 11 ай бұрын

😁I'm sure you will. It'll keep the brain cells active at least!

@localyaar.bf-tv3603 11 ай бұрын

thanks it's amazing

@MyOnlineTrainingHub 11 ай бұрын

I'm glad you like it 😊

@localyaar.bf-tv3603 9 ай бұрын

@@MyOnlineTrainingHub it's work now for me, thanks a lot

@harshadbarot 11 ай бұрын

Awesome information madam, I am really happy with this information

@MyOnlineTrainingHub 11 ай бұрын

So nice of you 🙏

@malchicken 10 ай бұрын

Thank you for this video. Where would you recommend I look to find more information on the different type of graphs available thru Seaborn? Thank you 🙏🏽.

@MyOnlineTrainingHub 10 ай бұрын

My pleasure. You can see the Seaborn graphs here: seaborn.pydata.org/examples/index.html

@chrism9037 11 ай бұрын

Cool stuff Mynda. Once I get a bit better with DAX and M Code, I’ll turn my attention to learning some Python!

@MyOnlineTrainingHub 11 ай бұрын

Yep, add it to the list 😁

@mohmmadabdo5899 11 ай бұрын

You are the best

@MyOnlineTrainingHub 11 ай бұрын

Too kind 😊🙏

@KM-co5mx 11 ай бұрын

Well that's rad!

@MyOnlineTrainingHub 11 ай бұрын

Sure is 😁

@tuancuong37 11 ай бұрын

this is the first time, i watch video after releasing 3 minutes :D

@MyOnlineTrainingHub 11 ай бұрын

Thanks for watching! Exciting times 😁

@marcovirtual 11 ай бұрын

Excel + Python is a game changer. The competition will have some catching up to do.

@MyOnlineTrainingHub 11 ай бұрын

Sure is!

@artsmith1347 10 ай бұрын

There is no catching up to do. M$ simply offloaded the cost of developing the scripting language to the open-source community. The competition has been better since the 80s. Excel and Word were not better than Quattro and WordPerfect. Maybe this misstep by M$ will push their Office products to the obscurity they have deserved.

@rrrprogram8667 11 ай бұрын

You are one of the best teachers of excel... Where r u from?

@MyOnlineTrainingHub 11 ай бұрын

Thank you so much! I'm from Australia 😊

@ExcelHechoFacil 11 ай бұрын

Gracias Mynda, es maravilloso ahora Python en Excel. Me encanto tu video. Felicitaciones.

@MyOnlineTrainingHub 11 ай бұрын

¡Muchas gracias!

@Fredick.7 11 ай бұрын

🙂...Extraordinaria noticia: A estudiar Python se ha dicho. Saludos Andrés.

@ExcelHechoFacil 11 ай бұрын

@@Fredick.7 Saludos Freddy, un abrazo fuerte amigo.

@HarshColby 11 ай бұрын

You're the first I've heard explain "enter =PY and tab". This is essential. If you just put =py and return, like you'd normally do, it won't work.

@MyOnlineTrainingHub 11 ай бұрын

Glad I could help! =PY( also works, or the keyboard shortcut which I prefer: CTRL+ALT+SHIFT+P

@kyth2583 11 ай бұрын

Hi Mynda, it still wont work with me using the shortcut either way.

@HarshColby 11 ай бұрын

@@kyth2583 Do you have the beta program and downloaded Version 2309 Build 16818.20000? In Excel (Microsoft 365), File => Account (on left near bottom) => "About Excel" should have that version number (or higher) and say "Beta Channel".

@hongjiachen8270 11 ай бұрын

Hi Mynda, this is amazing. Unfortunately, I don't have the privilege to give it try. I wonder what python libraries does it come with? Can user install custom packages with pip command? Since you mentioned it does come with pandas so I suppose reading data from various databases would not be an issue, but how about common packages such as openxl etc.

@MyOnlineTrainingHub 11 ай бұрын

Great to hear you're excited about it. Any libraries supported by Anaconda are available: www.anaconda.com/excel

@johnlug9655 20 күн бұрын

Legacy VBA can it be replaced with the Cloud based Python Packages? Could it interface with PowerQuery, too?

@MyOnlineTrainingHub 20 күн бұрын

No, Python in Excel cannot interact with other Excel tools other than formulas.

@brianvaddan9987 11 ай бұрын

That’s incredible thank you Mynda. A question, can the data frame reference a table housed in Power Query and included as a connection only in excel? That would take away the data size constraints of excel.

@MyOnlineTrainingHub 11 ай бұрын

Yes, it can 👍 next week’s video 😉

@brianvaddan9987 11 ай бұрын

Oh wow that’s brilliant- thank you for making these super insightful videos

@bennguyen1313 11 ай бұрын

If you have existing python projects, Is it possible to call excel functions? For example, a python script that programmatically send a list of numbers to Excel and have it return a trendline without ever opening Excel itself? I've seen some people use VS Studio / Ateasy to call functions from Excel via COM or OLE objects.. but I'd like to use Python (xlwings , openpyxl) to do it!

@MyOnlineTrainingHub 11 ай бұрын

That's an interesting question and wouldn't require the use of the new Python functionality inside of Excel. Not sure why you'd need to send a list of numbers to Excel to return a trendline with Python. You could do that all within the Python code without using Excel. Maybe I'm missing the point of your question.

@rxcst2 11 ай бұрын

Could you please advise what version of excel this is? I’m using MS 365 version 2208. But I don't have the function py as shown in your video.

@MyOnlineTrainingHub 11 ай бұрын

It's Office Insiders beta Version 2309 Build 16.0.16818.20000. You can join Office Insiders here: insider.microsoft365.com/en-us/join/windows

@xco4555 11 ай бұрын

Thanks for your useful video, if I send this file to another person PC, can they see it eventhough they haven't install the librabry like pandas ?

@MyOnlineTrainingHub 11 ай бұрын

Yes, absolutely 😊

@victoryusmd 11 ай бұрын

this future persists only in a special version of excel ? where we can see instalation process ,ty in advance

@MyOnlineTrainingHub 11 ай бұрын

There's no installation process. It's currently available to 365 users on the Office Insiders beta channel. You can sign up for it here for free: insider.microsoft365.com/en-us/join/windows

@ennykraft 11 ай бұрын

So far I can't see anything that really excites me but that might change when seeing more advanced examples. The charts alone wouldn't be incentive enough. I'm a graphics designer and often create charts but have found that simple ones everyone understands without a lengthy explanation work best. I certainly wouldn't pay extra for them.

@tobiisagoodboy7935 11 ай бұрын

@MyOnlineTrainingHub 11 ай бұрын

Python is vast and the libraries make it relatively easy to get started with. If you’re already using it then it’s a no brainer. If it’s new to you then there might not be any immediate need.

@millerdane 11 ай бұрын

It depends on how far you can see. Python and the libraries if offers is an absolute game changer here @ennykraft. Look at it this way, Microsoft will not spend the time and development effort to integrate a 3rd Party language into Excel if there wasn't going to be great advantages. The charts is just the tip of the iceberg.

@osvaldodipini6930 8 ай бұрын

Hi, I'm JUN. Thank you. I need more tips to learn. It's very educative.😅

@MyOnlineTrainingHub 8 ай бұрын

Glad you liked it 🙏

@Jallandhara 11 ай бұрын

Finally!

@MyOnlineTrainingHub 11 ай бұрын

Yep 😊

@razmangoudarzi4909 10 ай бұрын

Thank you for the wonderful video! It was truly informative and enlightening. I'd like to create a new sheet in my Excel file using the structure defined in Python code from another sheet. I'm having trouble writing the code to implement this. Could you assist me?

@MyOnlineTrainingHub 10 ай бұрын

Glad you liked it! My Python skills are still limited, but I wonder if the problem you're experiencing is due to the order of evaluation i.e. Python can only reference cells above or to the left of the active cell, likewise for sheets. e.g. Sheet1 cannot reference Python on Sheet2, assuming sheets are in numeric order in the file. Hope that helps.