big

Good Day I have a spreadsheet with multiple tabs. 3 of the tabs are created as dashboards and saved as a web page with the option to auto republish every time I save it. A week ago I added some new info on one of the dashboards. Ever since I did that the size of the dashboard is so big that...

I have a macro that searches one of my sheets in excel, let's call the sheet "Keywords". After searching it returns the matches. The Keywords sheet has a bunch of terms like "dog", "small", "big dog", "small white dog", etc. The problem I am having, and wondering if there is a way to teach...

Can anyone suggest a way I can do this? I get up to about 120 criteria before excel tells me that the formula is too big. Any suggestions of methods I could use to expand it to 900 (I know this sounds excessive)? Kind Regards.

I am using this formula =CELL("filename") which produces this result... C:\Users\Glen Munro\Dropbox\_VBA\___ MY BIG TEST\[to delete duplicate.xlsm]Sheet1 I would like to produce this result C:\Users\Glen Munro\Dropbox\_VBA\___ MY BIG TEST\to delete duplicate.xlsm I am solving this with a couple...

Hi, I've got a countsif <>0 formula that isn't working. I'm counting across a big number of columns, and it's every 3rd column. I've got...

Hi everyone, I have a excel file with 30+ tabs which makes the file about 3.6 mb. When I copy one individual sheet, it is still 3mb. I can't figure out what is causing it to be big. I even deleted all the rows and columns and there is no data anymore in the sheet but it is still big. We ran...

Hi, I'd like to be able to change my cursor into a big cross that takes all the screen, so that when I'm on excel it's easier to see the data at the same row at the far end of the screen. I don't mind if this change affects only excel or all the computer. Has anyone ever done this or knows...

I have a 723 KB MicroSoft Word file containing only a Table of four columns andabout 23000 rows on 455 pages. I wanted to sort on column four but MSWORD said that the table was too big for MSWORD. I have been told that Excel can manipulate it. Is that correct? if so, how can I easily get it...

Hi I have big sheet but I do not think that is the issue, anyway I want to sort a column which has numbers (1 to 4). I clicked anywhere on that column and then sort from A-Z. the first 43 rows were sorted fine but other rows were not sorted, I would have 1,3,4,1,1,4,3,3 etc what could cause...

Hello Team, I want to covert 00:50:56:A4:19:C0 into 0050.56A4.19C0. Can we do it in excel? i have the big list in the Row A

im trying to create a dropdown list were for example if i pick "bus-1234" the information under that changes as well. i'm trying to track 1616 buses with ongoing service issues. so i need a 365 rows with 4 columns. "A" will be the column numbers 1-365. "B" column is the date, "C" column is the...

Hello there, I'm thinking of using Excel to build a Database. Just normal information involving people, text entries mostly (name, address, phone# and such), some dates of course, maybe some numeric entries. The only particularity is that I'd be using some 40 columns and around 20,000 rows (a...