So I have been having this same problem for a long time.
I just work around it, by scrolling with my mouse, which can be tedious.
We used to have MS 2016, now we have Office 365. Problem existed on both.
The document is a shared document, old school, not the internet sharing because I need to be...
I have a PowerBi that recently started displaying incorrectly.
I just swapped my laptop too, and have the same issue, so it's an issue within PowerBi and I don't know how to solve it.
The menu's and top of the screen layout has disappeared and it makes it hard to work with
Sometimes when I have two excel workbooks open, If I click the cross on one to close it, the wrong workbook closes without saving. This even happens when the excel closed is on a different screen to the one I have closed.
Any ideas what could cause this?
I have a basic question that I haven't figured out. How do I post (paste) a screen print to a message I am posting? I see the Insert Image icon in the ribbon, but when selected it prompts for a URL. How do I post a picture stored locally on my computer to the question I am posting?
Hope you can help
I want a macro that can open a sheet in a new window.
Idealy it would do this.
When macro is run open Sheet"PDF Views" in new window and
place new window in middle of screen taking up about 75% of the screen
make that screen not show any tabs or...
I would like to open two windows folders on the screen and have them appear side by side on the monitor. I have the code below to open both folders and that part works fine. I just need to know how to size them and move one to the left side of the screen and one to the right side of the screen...
I can´t solve the issue with CONCATENATE and rounding in this function like this screen: https://ctrlv.cz/oEeL.
I need to round it only to 2 numbers after the decimal point (examlpe: 7.13%, not 7.15615615686164489%)
Can anyone help me with this function to solve it?
PS: Function is...
Not sure what is going on with this, I need my code to add a user selected hyperlink through the dialogue box, into a table on a different worksheet. I don't want to overwrite the current cell value with the screen tip either,
What it is doing, is adding the root part of the hyperlink...
Need help on below.
Basically, I want to combine all the data from worksheets into one worksheet. And this workbook is shared and will be used by multiple users at the same time and save the files before combine. However, when run the macro, it is not responding.
Sub Combine() Dim J...
I have a spreadsheet that has a rather large logo at the top. The logo is of where I work and I want the screen to rows 5:10 to free at the top of the screen so they will always be visible but anything above row 5, I want to scroll up as you go down the page. How do I do this?
I have a problem with the line chart i,e I am unable to show the data by week wise but I can able to see by day wise. Please help me to show the data by week and day wise like the below screen shot.
Please check the my output:
I used my order data for my axis and I can see by...
Folks, I have inherited a report which is causing me some grief. Originally, in .xlsm format it comes in at a hefty 300mb but its only 38000kb in .xlsb. So its not a large file. there are a handful of simple pivots stemming from source data held in dynamic named ranges, and a few navigational...
This recently appeared, and I can't put my finger if it was before or after my HD crashed...
When I launch Excel and hit Alt+F (Windows 10), it brings up the "Home" screen. (Not the Home TAB, the Home SCREEN. Argh, Microsoft!)
Underneath the templates, and the list of recently-used files, I'm...
I have a pivot table & I'm trying to get a difference from two columns within the pivot table.
This is a screen shot of pivot table.
This is a screen shot of the fields selected.
I've tried adding a...