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?

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

Probably not related, but I had the same issue with a time sheet I was saving on my desktop, that was linked to the company OneDrive. I didn’t realize I wasn’t logged in to the OneDrive and once I did it stopped.

Following for future reference.

This sounds like a problem that people run into when they create macros for Personal.xlsb. I did a bit of searching on "Excel personal keeps loading" and found this solution on the Microsoft forums. I haven't tried it, but I think it would work for you.

On your macro workbook, open the View ribbon and click Hide. Hide is in the Window sub-ribbon, a bit to the right of the View button you would have just clicked. Close Excel, and if Excel asks you to save the changes, click yes.

Related Posts

What corporate practice has better longevity if your goal is to stay in big law for as long as possible: M&A or Capital Markets?

like

After a decade of experience at big American banks plus consulting, with an American education and passport, how expansive are my options with big and/or small names in the region?

like

Hi, any consultant freelancing in Dubai? How do you go about finding gigs ? LinkedIn? Recruiters? Your personal network?

like

Does BNY Mellon not give anything in writing about the bonus that gets paid once a year?My cousin is negotiating an offer and they are only talking abt the fixed amount that will come on the offer letter and are assuring that the bonus will be paid out at the end of each year.

like

What can be the expected salary of machine learning engineer( fresher with only 1 year exp as python developer).

like

A few days later with time to process, what does everyone think of the ending?

Received a verbal offer on Friday for new company. I have yet to receive the official offer. Wondering if they have changed their minds.

like

Hello TCS fishes, Are there any fixed days in a week like Monday and Wednesday for onboarding in TCS? Or people can onboard any days of the week.

Anyone work in the Healthcare industry? I'm looking into joining Healthcare. I'm currently a Senior in tax compliance.

like

How do y’ll save money on taxes? Other than obvious routes like 401k.

like

Anyone from Accenture who is working on Cerner projects??

like

How long does is usually take to get staffed on the first project? Joined 11/15 and still no project... Fyi, I am in the commercial side. Should I be worried? Ive contacted my RM couple times and am reaching out to my network 😢

like

I was just offered a CUNY role. The title is Higher Education Assistant. According to Glassdoor, the average annual pay for that role is $83,418. However, I was offered $62,500. I requested for the minimum annual salary to be 75k. Does anyone have experience navigating the CUNY system and their pay?

like

Can we open New Salary bank account in Optum for lateral? Or its mandatory to provide last company's salary account details and continue with same bank?

like

Anyone here counsel for a parent company with a lot of subsidiaries but the parent company’s legal department is really really small? I’m wondering if a small legal department for a large company is more of a pro or con? On one hand I suspect it’s less organized, on the other it might be a great leadership opportunity. Any insight? Thanks!

like

Started at meta relativity recently and my hours have been crazy. I can’t tell if this is typical or just my team

likehelpful

AA: now that we are back to zero, what’s the best way to quickly get to Platinum? Currently Gold

like

Reach out if you have this experience

Post Photo

Do you fly out to family for the holidays or do they come to you? We're hosting Christmas for the first time and having the entire family come to town for it. What are some can't miss holiday events in the city? Ideally accessible because my father is in a wheelchair.

like

S&p global capital iq

like

Additional Posts in Excel Genius

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

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.

likefunny

How do I compare two sheets to make sure they are identical?

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

Best websites to get more of a handle on Excel as a beginner-intermediate?

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