opening

𝙷𝚎𝚕𝚕𝚘 𝚠𝚘𝚛𝚕𝚍 𝙵𝚘𝚛 𝚎𝚎𝚡𝚊𝚖𝚙𝚕𝚎, 𝚒𝚗 𝚊𝚌𝚌𝚎𝚜𝚜 𝚢𝚘𝚞 𝚌𝚊𝚗 𝚘𝚙𝚎𝚗 𝚓𝚞𝚜𝚝 𝚘𝚗𝚎 𝚏𝚒𝚕𝚎 𝚊𝚝 𝚊 𝚝𝚒𝚖𝚎. 𝙸 𝚊𝚖 𝚝𝚛𝚢𝚒𝚗𝚐 𝚝𝚘 𝚊𝚊𝚌𝚑𝚒𝚎𝚟𝚎 𝚝𝚑𝚊𝚝 𝚒𝚗 𝚎𝚡𝚌𝚎𝚕. 𝚜𝚘 𝚠𝚑𝚎𝚗 𝚒 𝚊𝚖 𝚘𝚙𝚎𝚗𝚒𝚗𝚐 𝚖𝚢 𝚏𝚒𝚕𝚎 𝚒 𝚌𝚊𝚗 𝚌𝚘𝚞𝚗𝚝 𝚝𝚑𝚎 𝚗𝚗𝚞𝚖𝚋𝚎𝚛 𝚘𝚏 𝚘𝚙𝚎𝚗𝚎𝚍 𝚠𝚘𝚛𝚔𝚋𝚘𝚘𝚔𝚜 𝚝𝚑𝚎𝚗 𝚌𝚕𝚘𝚜𝚎 𝚖𝚢 𝚏𝚒𝚕𝚎 𝚘𝚛 𝚘𝚝𝚑𝚎𝚛𝚠𝚒𝚜𝚎 𝚃𝚑𝚎 𝚘𝚗𝚕𝚢 𝚒𝚜𝚜𝚞𝚎 𝚒 𝚑𝚊𝚟𝚎 𝚗𝚘𝚠 𝚒𝚜 𝚑𝚘𝚠 𝚝𝚘 𝚍𝚎𝚝𝚎𝚌𝚝 that when I am trying to open...

Hello everybody, Whenever I open my excel sheet I get the following message: "We found a problem with some content in "File name xxx". Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes" It is super annoying. It started happening after I...

Hi, Right now, once a week I need to open a file, refresh the table, save and close the file. Is it possible for excel to automatically update itself without opening it once per week? Thanks in advance.

Hi, I have a workbook which collects data from 80 other workbooks. My macro is taking a painful 30 minutes to open, copy, paste and close all of those 80 workbooks. I'm using workbooks.open(filename, True, True). I've concluded that what takes time is opening the files, so I'm looking for a...

Hi all I’m looking for a way to prevent people from opening a workbook between 2-2:30pm every day. So it can be updated on the server. I have set a Application.OnTime vba to close at a set time 1:59 and then repeated it every min until 2:29. But people are still able to open the work book...

I have been creating several spreadsheets at work and there is a problem with opening more than 1 instance of them at the same time on a network. I have one spreadsheet called "quoting tool" that generates quotes. When quotes are finalised they are sent to separate spreadsheets called allocation...

Hi, I have a simple worksheet with daily stock entry and withdrawal for different items (based on a validation list). Column A = product description (items from the validation data list) Column B = Opening stock Column C = Withdrawal stock Column D = Closing stock I want to find...

Hi All, I have a sheet where it records a time when one of our trucks goes into a dealer. It also records the time the trucks leaves the dealer. I would like to workout how long the vehicle has been stood in the dealer. That is easy to do, but in order to be accurate, I would like the...

Hello! How can we print excel workbooks in a one folder without opening the file? Thank you for your help!@

For several excel files, when i open them, the file quickly cycles through every visible tab.This does not happen for all files, but most of them. In addition, some files have macros while others do not. I sent one of the files I was experiencing this issue on to a coworker, and she opened the...

Well... for example, I remained on `Developer` tab. I сlosed the book, started it and with opening `Developer` tab! Is it possible?

So here is what I have...please help I have created three sheets in Excel. The first sheet contains the actual data The second sheet contains an audit log that is already set up through VBA code. The third sheet is a user list of all the authorized users that will be able to access the...

Hello. When opening Excel files that contain links to other files, I often get a message in the lower right of my screen that says "Linking: (file name)" with a status bar (please see attached photo). This would not be a problem except that Excel seems to "pause" at this point for several...

Hi Excel-wizards! This is my first post having been a distant follower for a while - so go easy on me ;) I have a number of .xls workbooks which have lots of files inserted into them (Insert>Object>Create from file>Display as icon). These files are usually .pdfs but there’s often others...

Hi folks, very new to Excel and need to do a chart that im not too sure how to do, although im sure its possible with how exceptional of a program this is. Basically, I need to do a chart (bars probably easiest), that would have Sunday to Saturday along the top and opening hours along the Y...

Is it possible to specify the path and filename of an xls file and use it as a reference without opening it? In VBA or formulas. Thanks!

I have set up three reports to generate overnight and create 3 .csv filesI have created a spreadsheet where these csv files are read by the data model and from there, create power pivot tables.The requirement is that the pivot tables read the most current data whenever they are opened - they are...

Sheet Name: 'TOOLS!' <tbody> A B C 1 Opening Max Bend Tool 2 0.520 150 ABC 3 1.125 105 DEF 4 2.000 95 GHI 5 3.000 100 JKL </tbody> Sheet Name: 'CHART!' <tbody> A B C 1 Material Pref Opening Use Tool 2 10GA 1.125 ??? 3 8GA 2.000 </tbody> There are several...

Wanting data source to refesh on opening Workbook however most of the options are greyed out. In particular "Refresh data when opening the file" Any advice appreciated.

Hi all, i would like to prepare a VBA code so that to run through col. "F" and where the text is like "Opening Balance" and in col. "J" is zero number "0" should delete entire row. Please see below an extract of my data row "28" which i wanted to delete. Thank you all in advance...