Forum

Hi Steven, Can you upload a sample file that replicates the problem? We cannot debug without analyzing the file unfortunately. Thank you

Hi Javier, Try opening Internet Options from Internet Explorer: In Internet Explorer, click Tools, and then click Internet Options. Click the Conte...

Hi Hans, Not a long time ago, there was a security measure implemented related to macros downloaded from internet. See this feb 2023 article her...

Hi Karl, Just before that line in code, add a Debug.Print to see at what folder it fails: Debug.Print StartingFolder.Path NewRow.Cells(1, 1)....

Before refresh, unprotect the sheet: tbl.Parent.Unprotect Password:="Your password here" tbl.QueryTable.Refresh BackgroundQuery:=False B...

You have to adjust the code to your file. Replace in code SheetName and TableName with your real values, I lost my crystal ball to see these names in ...

Hi Leah, The code should look like this: Sub RefreshTable() Dim tbl as listobject Set tbl=ThisWorkbook.Worksheets("SheetName").ListO...

Hi Scotty, You can adjust this code for your specific needs:

however, manual row heights are never preserved, Wrap text will be the way to go, unless you used vba code to set the row height to a specific value.

Hi Leah, Make sure table is set to preserve cell formatting, after you set the table data range to Wrap Text if you want to wrap it.

Hi Wendy, Try these queries please: Name this query "GetHolidaysData": (region as text, year as text)=> let Source = Web.Page(Web.Conten...

Hi Teja, I'm afraid we have no control in this problem, it's related to windows versions and display monitor, the display should use sRGB emulation...

Hi Wendy, You have to provide your attempts and indicate the step that fails and the error message, it will be much easier to understand the proble...

Hi Tony, Database should be the smallest challenge, any database will work fine: SQL Server, MySQL or any. Facebook is also using MySQL, they have mas...

Hi David, Looks like you are not using a dimension table for AccountNumber. If you create it and use it in the visual and formula, it will work.