custom views

I'm using Microsoft 365 for Enterprise, and I'm running into a weird bug trying to apply Custom Views to my workbook. Was wondering if anyone knew what was going on or how to get more debugging information! I've got a fairly large spreadsheet, and one of the sheets has a small amount of data...

Hi all, I am quite new with macros in excel, and I was wondering if it is possible to print multiple custom views in one pdf. For example, I have two custom views named as "CV_1" and "CV_2". How can I print both custom views in a single pdf? Also, would it be possible to print multiple...

I'm setting a custom view that has certain filters set on my data. I'm filtering by 2 columns. Once I've applied the custom view, I go to Data-> Sort & Filter-> Clear so that I can see all of my data again. When I do that, the data that was filtered out of my custom view (ie not showing)...

Hello, Three of my users (Amanda, Beth, and Rose) have a shared spreadsheet file. It is a large file with 30 tabs and ton of information. Last week they took 10 tabs each and did their edits. Whatever data three of them entered or edited, got saved and shows up on each computer when they...

I am working on a large workbook with many worksheets and a lot going on (macros, custom views, hyperlinks) .. . I put the worksheet at 100% and B1 is hilighted. When I go to another worksheet and come back, it reverts back to 75%. Also, columns are hilightd, so I click in B1, and when I...

I have a worksheet that I use to create a report each month. I have saved 6 custom views to print the various pages of the report, 3 custom views on one sheet and one on each of 3 other sheets. To compile my report, I currently select each custom view, save as PDF, and then use adobe acrobat to...

I have a few concurrent projects at the moment. A couple of them are really simple, yet really fun! A major improvement I'm making on both is the set-up of CUSTOM VIEWS. Job #1: The client uses the template to input actuals, budget and a couple of different forecast versions. The model also...

I have a large spreadsheet from which I need to create separate Reports by hiding various rows and columns. I have followed instructions for creating a couple of Custom Views (View tab, Custom Views, Add, Inserted Name, OK, Saved the document) but nothing happens apart from getting the message...

I have a spreadsheet with thousands of items, which need to be categorized. I created dozens of custom views, based off very specific filtering of the columns, and saved them. (I'm using Excel 2010). Afterwards, I added in another column, showing more descriptions per item. I noticed that the...

Hello to all, I have the following code that is working very nicely. Sub View_Show_Budgeting() Application.ScreenUpdating = False Dim rowVar As Integer rowVar = ActiveCell.Row If Range("ChangeOrderStatus") = 0 Then ActiveWorkbook.CustomViews("Budgeting").Show...