I have a budget spreadsheet that was created using Excel 97-03. My boss sends it to me, I try to update some fields and I get this error, and the formula wipes out. I am NOT writing over the formula, just inputting data and somehow the calculation gets lost. It's a compatibility issue for sure, but when he converted to just a simple excel workbook file, whenever he emails it to me, I'm still getting the same error. How can I convert or update the file without losing all the formulas?

Anyone has details on hierarchy and salary details in Wells fargo? Applying for senior product manager - business analyst role.

How do you detach your self worth from your job? I have a lot of good things in my life and generally like myself as a person, but if I feel like I’m under performing, everything else feels bad

If you do billable work on a given PTO/vacation day, do you still count that day as vacation? Or do you get that vacation day "back"? Or do you only get the part that you billed "back"? (Or some other option.)

Great Idea: Let's mandate RTO industry-wide to kick off flu season.

Does anyone actually get jobs through using LinkedIn easy apply? If there’s a cover letter submission component- how important is that part? In general are cover letters super important?

Why is it taking forever to get an offer letter… I got a verbal offer but still waiting for the official letter for 2weeks. Recruiter gives me heads up that it’ll take couple of weeks but still.. i’m so nervous. Should i concern? My mental is about to go crazy haha

Does anyone have an experience that all went well and right before the offer letter, it just get cancelled?

Moving to industry and trying to decide start date. Would I still be eligible for the performance bonus if I put in my two weeks notice a week before receiving the bonus?

We are a family with 2 kids under 3 years.
Yoe : 13 - 40 lpa
Yoe : 10 - 20 lpa.

Watched on YouTube about the Netherlands biking culture and how it's a good place for kids. Thinking of staying long term and sending kids to Dutch school.

Just beginning to apply via LinkedIn.
Both of us plan to work and needed inputs on what combined salary would make sense.
Would it be good to accept an opportunity if one us of us gets 60keuro and hope spouse would get an opportunity once we move there?

How can i switch from tech consulting to strategy?

Hey ,I applied 3 weeks ago to Bank of America with a decent resume and referral. But still did not heard back.Need a human eye who is willing to check my application and help me moving to the next step?@BankofAmerica

I have been in my current job for 1 year now as a booking coordinator for a logistics company. When I started I had no idea of what my workload would be, now I noticed that my coworkers took the opportunity to pass most of their job to me. I’m burned out, can barely take break and end my days totally drained and exhausted, also the same people is harassing me with questions like: “why are you working that slow?” Or the “quality of your job is questionable because…..” continue in comments

Is there a way to practice L&E in the government realm? If so what’s a good way to find these positions? Thanks!

Is there an internal transfer process? I'm new to the firm, in consulting but in another OP.

Belltown vs SLU vs Capitol Hill? Moving to Seattle and haven't had an opportunity to properly evaluated the neighborhoods so curious what the pros and cons for each are

If only this bowl was made months ago:/ about to move out of Jax.

How Fidelity Banagalore provides the compensation ? Is that good ?

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

Still don't have xlookup. #fomo

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

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?

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?