Today I encountered the strangest bug I have ever seen with Excel+Thinkcell. I have, as always, a separate Thinkcell sheet where I gather and structure the data (from other sheets) I want to make charts of. However, when linking this data to charts, all formulas in the sheet turns into values. This has never happened before. Anyone else seen this and knows what is going on?

like
Posting as :
works at
You are currently posting as works at

Did you change the excel file name?

Yes and no. I have tried multiple things, including taking a new workbook, pasting all content from the old one, making a new chart and linking it but the same thing happened. If I however make the simplest test with inter-sheet formulas to dummy values in an empty workbook and link to a dummy chart in a new PPT it works fine.

like

Related Posts

Will it ever not be a boy's club?

like

I have a question about pricing. Some context to my upcoming question: My brother and I are starting a personal training business. I have six years military experience and he is still in the military. Collectively we have passed the hardest schools in the military and both love fitness and have experience building programs and are both certified personal trainers. I don’t know weather we should charge on the higher spectrum because of our experience or lower because of our business infancy.

Anyone in here lives in the DMV area?

like

I have accepted an offer for the role of Director of Data Science & Analytics and I'll be working with old colleagues. I am very excited. I haven't given notice yet because I am waiting for the background check to complete, but my boss just asked me about traveling to a meeting in November. I start at the new job Oct 25. I'm really struggling for how to respond. If I were not leaving it is absolutely a meeting I should be at. I don't want to respond with a lie. Any dvice on how to respond?

likesmart

My lease ends by end of May and I will be out of town for June and maybe the first 2 weekz of July. Does it make sense to put my stuff in a storage and save that months rent or should I move to a new apartment and eat the rent (assume $1800/mo) for those 6 weeks?

like
like

It is very much probable that the US and some of the EU countries might venture into recession.

Considering the same, is it advisable to join EY GDS at this juncture as there is a probation period?

like

EXL…. A tatti company. Please don’t ever join.

like

Is it legal for a government client to tell a consulting firm that they don’t want people (contractors) leaving the project ?

Anyone refer for java 6 years experience for ford? Lwd 22 aug

Is there any opening in Servicenow development. Let me know if, you come to know of any. EXP: 2.5 years. Requirement for a friend

like

I am looking for a job

like

Happy to report: Did not fall into any honey trap at the holiday party.

like

How much time does HTC global takes for offer letter generation? I had my Client interview yesterday afternoon got confirmation from HR @ around 9.30 pm to submit the relevant documents ASAP . I did send all the documents yesterday night itself.

likehelpful

Every time MD replies "jumping into the slides now", I need to hug my stuffed animal so tight to manage my stress. AND I'm 35 already.

Post Photo
likefunnyupliftingsmart

Got an offer from Infosys and Capgemini as a consultant.. looking for honest feedback.

like
like

I heard that, their is hire and fire policy in Synechron, can anyone tell me the reason they fire the employees?

like

What are your hours like as a clerk? I’m sure it varies a lot based on the judge but curious to hear people’s experiences

like

Additional Posts in Excel Genius

Can anybody recommend any excel courses to take for financial analysis? Modeling, valuations, etc. Any direction would be helpful.@

likehelpful

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Anyone have a good source to learn sql

like

How do you fix microsoft excel cannot paste data error?

like

What would you consider "Advanced" or "Expert" level Excel usage?

like

How long did it take you to become good at excel? Like fast?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Each country has multiple txns. Some complete, some not. What formula should I use to say if Indonesia has ANY “not complete” then show me the term “not done”. Tried IF(Index Match) but only (cont.)

Post Photo
like

Question for those of us that dabble across data science and not just excel. I want to get some good training on SQL. Anybody know the best certification program that has the best cache in the market?

like

Top 3 most useful VBA macro codes you use everyday? Would you mind sharing the VBA code or a link showing the code? I’ll start (cont.)

likehelpful

I have 1 sheet with names and sheet 2 with a large list of names that may or may not be those names - which also have corresponding unique identity numbers. How do I easily match the names with the same names and keep the unique identity numbers for importing later?

Any book recommendations on excel modeling for real world business applications?

like

Hey!

What are the less known skills in Excel worth learning which are also high in demand in the market?

PS: I am starting off on Fishbowl so please support with a ❤️.

like

Need help with a formula. I’m downloading bank statements to excel and I’m trying to do a lookup so it fills in the category based on the bank description. The problem is I’m trying to use the entire bank description as my lookup value, but the table array I’m searching only has the first part of the descriptions (because the last parts are all different bank ref numbers). How can I do this?

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Hi! I’m trying to create a macro that pulls a copy of a sheet from a file with a certain date in the file name into a new workbook. Is there a way to do this?

How can I resize the horizontal scroll bar to only fit to my data? It goes all the way to column XFD and my data only goes to GK. Someone once had formatting that far out and now it won’t resize

likeupliftinghelpful

How useful are Macros and VBAs for tax prep?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal